eliminating blank rows from a field in a report

H

HAB

I am creating a subreport for a text field that may or may not contain data.
I only want the rows to print that contain data. How do I indicate that only
those rows with data should be displayed on the report?

I'm sure that this is basic...but I'm completely new at this! I'm using
Access 07.
 
A

Allen Browne

So you want to leave out all the records where this field is blank?

Create a query. In the Criteria row under this field, enter:
Is Not Null
Save the query.
Use it as the RecordSource for the report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top