Error in the query statement. (1 Viewer)

[azhar2006]

Hi guys
I have created a query and I used this expression in one of the query fields, but I encounter an error in the sentence. Can you help me fix the error
Thanks to all .

[Forms]![frmRptDeprmnt]![Combo];[Department];[Forms]![frmRptDeprmnt]![Combo]

 

[June7]

That is not valid expression for a field. Exactly what are you trying to accomplish?

 

[azhar2006]

That is not valid expression for a field. Exactly what are you trying to accomplish?

Thank you very much for replying. I'm trying to do filter

 

[June7]

Review http://allenbrowne.com/ser-62.html

 

[The_Doc_Man]

In a query, you typically use a WHERE clause in SQL. In the query grid, you would put your filter in the criteria lines. Describe the actual goal here in language, not code or query-grid fragments.

If you are trying to filter something, first note that you filtered by the same thing twice. I'll also ask this: What did you THINK or HOPE would be the result of the syntax you used? We have to figure out intent in order to tell you the right way to do this. Not that it can't be done, but as you have determined, you don't do it that way.