Status Selection

[Guest]

I have set up an Access file which includes over 500 records of employees who
have attended a required training class. They have two chances to pass, and
the information is indicated as follows:

Passed first training. (Y/N)
Passed first exam. (Y/N)
Eligible to attend second training. (Y/N)
Passed second exam. (Y/N)

However, there are those who signed up for the 1st class but had to cancel
for any reason wherein this information is included in the Status field
information. I finally was able to set up the query criteria for the Y/N
columns, but the Status field only appears for those found in the query
results above.

Can anyone provide assistance on how to retrieve the records with
information in the status field whether or not the record has Y/N in the
other fields?

Thanks.

 

[Guest]

What kind of field is the status field? You mention four Y/N fields but not
what is in the status field.
Why not us an option group instead of the four Y/N fields with one integer
field?