Select "autonumbers" not in sequence

[jerry525]

Looking for a way to select certain records out of a data base that has an "Autonumber" field, and a "First name" and "Last Name".



Criteria: When I try ="1", "5", "12" etc. (the "AutoNumber" field) it doesn't work

When I try Like "1", "4", "9" etc. it doesnt' work

What is the proper expression to select records using the "AutoNumber" as the field to use to base the select on?

Thanks!

Jerry525

[RuralGuy]

An AutoNumber field is a Long Integer numerical field, not a "text" field. Drop the quotes.

[jerry525]

Thanks Ruralguy

I tried dropping the quotes and still no success


Like 1, 3, 7

= 1, 3, 7

etc. etc.

Can you use the three records above and type in the criteria that will return those three records in my query?

Thanks!

[RuralGuy]

You will need to OR them together. How about posting the SQL view of the query?

[jerry525]

RuralGuy

Like 1 or 2 or 5 etc etc

Thanks! That worked.

jerry525

[RuralGuy]

Excellent! Thanks for posting back with your success.