Criteria Expression Problem

  • Thread starter Thread starter antmorano
  • Start date Start date
A

antmorano

Good Afternoon:

I have 9 sets of criteria that I entered on 9 different lines in
access. My first line consists of criteria for Retirees only. Right
now I have: [Retiree Eligibility Date] <Date(), [Retiree DOD] Is
Null, [Status of Coverage- Retiree] <>"Cancelled", [Retiree Age] ,65.
I have one retiree that is not making the list and fits all criteria.
Does nayone have any suggestions on why she isn't making the list?
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 
I would guess that she doesn't meet the criteria for some reason. Ok, smart
*ss answer over.

Some things to look at.

If Retiree DOD a date field? Or is it a text field? If it is a text field,
are zero-length strings allowed?

Is the Retiree Eligibility date filled in?

Is Retiree Age filled in? Is it less than 65? Is it a calculation?

Is Status of coverage Null? IF so that will lead to a failure to match the
criteria.

I know al those are fairly obvious, but almost every time I have a problem
like this, I find it is data-driven.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I see what looks like a syntax error --- [Retiree Age] ,65.
Should this be [Retiree Age] >= 65
 
Back
Top