Filter a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I want to only display the records where PerslNme is not
blank. I would also like to know how to display only the records that are
blank. There are other fields in the report so knowing how to filter for the
blank/null value on that field would also be used and useful to know. The
report name is NMEList. Thank you.
 
Write code (possible the On Click event of a command button) like:

Dim strWhere as String
strWhere = "IsNull(PerslNme)"
DoCmd.OpenReport "NMEList", acPreview, , strWhere
 
Back
Top