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:
- Open your report in Design View.
- Right-click the square at the upper left, and then choose
Properties.
- In Access 2007, under "Property Sheet", click the
Generaltab.In other versions of Access, in the
Reportsdialog box, select either theAlltab or theDatatab. - 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 <> ""
- Click inside the "Filter on Load" (Access 2007) or "Filter On"
(other versions) box, and then, from the drop-down menu, select
Yes.
- Save your report, and then close it. From the
Viewmenu, selectLayout PrevieworPrint Previewto view the filtered data.
This is document aeso in domain all.
Last modified on May 13, 2009.
Last modified on May 13, 2009.







