Criteria for Selecting A Range of Values

  • Thread starter Thread starter adamsjw2
  • Start date Start date
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
 
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
 
Back
Top