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
 

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

Selecting two ranges on two fields in same query 3
Having multiple values from a form field as criteria for a query 0
Trouble finding Data using criteria 5
sum based on criteria 1
Updateable Query 2
setting criteria for time value search in select queries 1
Criteria across the board? 6
Changing Year in Date Range 1

Top