I don't want blank fields.

[Guest]

I have a table with fields containing "Correct", "Incorrect" and "N/A". I
have created a query to pull any field with a criteria of "Incorrect". Now I
have a report that generates from that query. How do I get the report to
only show the field with an "Incorrect" rather than showing the entire record
with one field marked "incorrect"?

Thanks

 

[Guest]

How do you know which field is incorrect?

 

[Guest]

In the table, certain records may have one of the fields marked incorrect.
In my query, I have it setup to pull the criteria of "Incorrect" for each
field using or and set up staggering on a different line for each field. I
want to only see the field that has an "incorrect" and not the enitre record
showing the rest of the fields as "correct" or "N/A".

 

[Guest]

When you say these fields are "marked", what do you mean? Do you mean you
have a field named (for example) [FOO_BAR] and another field in the table
([FOO_BAR_STATUS] that will have the marking in it?

 

[Guest]

In the table, the user has the option to select one of three options in a
drop down. Incorrect, correct or N/A. No field is left blank. In my query,
I am asking to see anything that says incorrect. I understand that it will
retrun any entire record that has one of the field marked incorrect.
However, It is way too much data to put into a report and I only want to see
the idividual fields marked incorrect for each record ID.

When you say these fields are "marked", what do you mean? Do you mean you
have a field named (for example) [FOO_BAR] and another field in the table
([FOO_BAR_STATUS] that will have the marking in it?
--
Dave Hargis, Microsoft Access MVP

In the table, certain records may have one of the fields marked incorrect.
In my query, I have it setup to pull the criteria of "Incorrect" for each
field using or and set up staggering on a different line for each field. I
want to only see the field that has an "incorrect" and not the enitre record
showing the rest of the fields as "correct" or "N/A".