Filter a report Billy B 29.09.2006 21:30:02 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.

Re: Filter a report "Duane Hookom" <DuaneAtNoSpanHookomDotNet> 30.09.2006 03:43:23 Write code (possible the On Click event of a command button) like: Dim strWhere as String strWhere = "IsNull(PerslNme)" DoCmd.OpenReport "NMEList", acPreview, , strWhere -- Duane Hookom MS Access MVP "Billy B" <BillyB[ at ]discussions.microsoft.com> wrote in message news:AC6AA8E4-4DA8-4156-BA20-BBD4496DC4C9[ at ]microsoft.com... [Quoted Text] >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.