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

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

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