eliminating blank rows from a field in a report

  • Thread starter Thread starter HAB
  • Start date Start date
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.
 
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

Back
Top