Omit entire entries if a field in the entry is empty?

[Guest]

I'm trying to generate a report that will serve as an address label sheet.
The problem is that some of my contacts don't have the address field filled
in and I'd like to have those entries not show up.

I have very little experience writing macros and such, but I'm willing to
try it. If that's what it takes to fix this then I only request that the
instructions be fairly detailed.

 

[Marshall Barton]

I'm trying to generate a report that will serve as an address label sheet.
The problem is that some of my contacts don't have the address field filled
in and I'd like to have those entries not show up.

I have very little experience writing macros and such, but I'm willing to
try it. If that's what it takes to fix this then I only request that the
instructions be fairly detailed.

The report's data should be filtered in the report's record
source query. Set the Address field's criteria to
Is Not Null

 

[Guest]

Bomb diggity. Thanks a bunch. I trying to build it straight into the reports
and that wasn't working so well, but this worked perfectly. Thanks again.