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.
 
Back
Top