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

M

makuro

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.
 
M

Marshall Barton

makuro said:
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.
Click to expand...


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

Makuro

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.
 
Top