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
 
Back
Top