Criteria for Selecting A Range of Values

A

adamsjw2

Greetings all,
I have a table of clients, each with a unique primary diagnosis
I need to create a query which selects

clients with certain diagnosis.

I'm designing the query as follows:

Field One: SSN
Filed Two: PriDiag
Criteria: Between 305.00-305.99 or
Between 290.00 - 292.80

I know this should be fairly simple, but I can't find the answer
anywhere else.
Thanks Much,
Jim
 
S

Sebastian

You should just have to put the following in the criteria
field under PriDiag:
1st Line Between "305.00" And "305.99"
2nd Line Between "290.00" And "292.80"

Sebastian
 
Top