How to skip blanks when printing report

S

Stilla

Hi. My access tool stores interview responses. I am building reports to
print out responses to each question, showing name and some other
demographics. No problem - all straightforward. What I'd like to know is
how to skip those people who did not have a response, so that my report isn't
sprinkled with blanks, and it only lists those who had an answer to a
particular question.

Thanks so much!
 
J

Jerry Whittle

Create a query that excludes those records and use it as the record source
for the report.
 
S

Stilla

OK, thanks. Do I have to know which exact records have blanks to create this
type of query? My user will be using a print report button to print this
report and I want to automate it as much as possible...so I would want it to
automatically exclude say record number 40, if there is no text in a certain
field.

Thanks again.
 
J

Jerry Whittle

In the query design grid, put "Is Not Null" (without quotes) in the criteria
under the field in question.
 
Top