Criteria Expression Problem

[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?

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[John Spencer]

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
..

 

[KARL DEWEY]

I see what looks like a syntax error --- [Retiree Age] ,65.
Should this be [Retiree Age] >= 65