Sort or Filter

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have a make table query and I'm trying to sort on a
field entitled type code:

I only want to see the following types:

R01
R03
R15
R21
R22
R29
R37
P01
U01
U19

Can I go into the critiera section and list only the above?
I tried but I received a syntax error. I want to filter
within my query only the above types within the type field.
Keep in mind the type field has over 25 different types.
I need step by step instructions on how to accomplish this.
 
Try using criteria of
IN ("R01","R03",...,"U19")

If this doesn't work, perhaps you can post the SQL statement. Along with any
error messages, or what unexpected results you are getting.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
 

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

Query using multiple values from one text box 7
AND query 4
Filtering 1
Delete All Instances of Duplicates 7
calculating results within a query 1
Access Dcount (multiple criteria) 3
Filter out values of £0.00 in a query 3
Date filter 2

Back
Top