Getting Access to Look Past the First Criteria

[Guest]

All,

I have an Access 2002 database with 34 records. Each record tracks up to 16
milestones (minimum of 5). Each milestone has a status code of either green,
yellow, red, white or gray. I need to pull all of the records that have ANY
milestone that is not green or white.

I have tried "or" statements in the query ("red" or "yellow" or "gray") for
each status in the table structure, but it consistently pulls 8 records. Each
of those records has one of those colors as the first milestone. I need
Access to look BEYOND the first one (which is green in some cases)to the
milestones that occur later in the file structure.

Anyone have any ideas? Suggestions would be much appreciated.

 

[Tom Ellison]

Dear Lori:

This problem will probably be much easier to diagnose if you would
show us the query you are using. Could you supply the SQL text for it
in your next post?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts