Filter a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Billy B - 29 Sep 2006 22:30 GMT

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.

Reply to this Message

Duane Hookom - 30 Sep 2006 04:43 GMT

Write code (possible the On Click event of a command button) like:

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

Signature

Duane Hookom
MS Access MVP

>I have a report that I want to only display the records where PerslNme is
>not
[quoted text clipped - 3 lines]
> blank/null value on that field would also be used and useful to know. The
> report name is NMEList. Thank you.

Reply to this Message