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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
hi,
in the criteria pane of the department field enter
"318" or "384" or "365" or "367" or "368" or "369"
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with totals function in query 2
Using form to fill in query criteria not working 2
Using a combobox value and wildcards to filter a query 4
how do i? 7
Criteria & <> 4
How do I filter fields based on date ranges 2
Union Query Help 1
Criteria and sorting 2

Back
Top