Query Criteria

[ravynfaire via AccessMonster.com]

Good morning,

I am having a problem where I have designed a query and I have it looking up
certain criteria in 3 fields.

Date - Between [Type the beginning date:] And [Type the ending date:]

Position - "PM/PE"

Status - "Started" Or "Accepted" Or "No Interest" Or "Counter Offer" Or
"Interview Scheduled"
(second or) "Offer Mailed" Or "Pending Interview" Or "Will be starting" Or
"Verbal Offer" Or "Waiting on Evaluations" Or "Waiting on Feedback" Or "On
Hold"


Now, when I click on it, it pulls up the right date and the right status
information but it pulls up all kinds of information for the position (such
as contracts, admin, etc.)

How can I fix this?

Thanks for your help ahead of time.

Megan

--
We may encounter many defeats
but we must not be defeated
- Maya Angelou

Message posted via AccessMonster.com

 

[John Spencer]

You either need to repeat the first two criteria on the second criteria line
OR use alternative syntax for Status (use IN( Comma separated list) )OR get
all the status on the same line. Right now you query is getting records
based on two sets of criteria

A) Date range plus Postion plus the status based on the first "Or" line
plus
B) Status on the second "Or" line - ignoring Date range and Position.


Try the following
Date - Between [Type the beginning date:] And [Type the ending date:]

Position - "PM/PE"

Status - IN("Started" ,"Accepted" ,"No Interest" ,"Counter Offer"
,"Interview Scheduled", "Offer Mailed" ,"Pending Interview" ,"Will be
starting" ,"Verbal Offer" ,"Waiting on Evaluations" ,"Waiting on Feedback"
,"On Hold")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[ravynfaire via AccessMonster.com]

Thank you for your help with this. I got it fixed and my boss is going to be
really pleased.

--
We may encounter many defeats
but we must not be defeated
- Maya Angelou

Message posted via AccessMonster.com