Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

In Microsoft Access, how can I prevent records with blank fields from appearing in a report?

In Microsoft Access, to prevent records with blank fields from appearing in a report:

  1. Open your report in Design View.

  2. Right-click the square at the upper left, and then choose Properties.

  3. In Access 2007, under "Property Sheet", click the General tab.

    In other versions of Access, in the Reports dialog box, select either the All tab or the Data tab.

  4. In the "Filter" text box, enter the text that you wish to filter. For example, if you wanted to leave out records where a field called "status" was blank, the filter would be: status <> ""
  5. Click inside the "Filter on Load" (Access 2007) or "Filter On" (other versions) box, and then, from the drop-down menu, select Yes.

  6. Save your report, and then close it. From the View menu, select Layout Preview or Print Preview to view the filtered data.
This is document aeso in domain all.
Last modified on May 13, 2009.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.