I don't want blank fields.

S

SDH@DJ

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
 
S

SDH@DJ

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

Klatuu

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

SDH@DJ

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.

Klatuu said:
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


SDH@DJ said:
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".
Click to expand...
Click to expand...
 
Top