How do I sort criteria with Arithmetic operators ex.>315 but <387

S

Shimika

I am trying to create a query that will only pull information from certain
departments. For example, I only want information from Department 318,
384,365, 366, 367, 368, and 369.
 
G

Guest

hi,
in the criteria pane of the department field enter
"318" or "384" or "365" or "367" or "368" or "369"
 
M

Marshall Barton

Shimika said:
I am trying to create a query that will only pull information from certain
departments. For example, I only want information from Department 318,
384,365, 366, 367, 368, and 369.
Click to expand...


Other ways are to use a criteria of:

IN(318, 384,365, 366, 367, 368, 369)
or
In(318, 384) OR (>=365 AND <=369)
 
Top