How to *not* put a field on a report

Piet,

I just wanted to Thank You for your efforts.

I'm betting your way works too... I think I'm just too green a newbie to
implement it properly.

But I sure appreciate you trying to help me out.

James


wrote in message
ps.com...
On Aug 12, 2:20 am, "James Ivey" wrote:
Sheesh... I didn't word this very well.

The fields are called:
Phone_on_list Yes/No (combo box)
Email_on_list Yes/No (combo box)

So, the statement would be:
If Phone_on_list = No, then don't print it on the Report.

Hope that helps.

James

"James Ivey" wrote in message

...

Access newbie here. Am not a programmer, so I need help with this one.

I've created a simple little database with membership info for our
organization of approx 450 members. Name, Address, email, phone
numbers... a few other bits of info.

I've got a field on the form called "Don't include email in Directory"
with a Yes or No combo box.

Same deal with the phone number.

Each year we print a Membership Directory with Name, Address, Phone and
Email.

I've set this up in Access with a Report using the mailing labels
report.

Several members don't want their Email address or Phone number in the
Directory.

What I want to do, is say:

If "Don't include email in Directory" = Yes, then don't put it on the
Report

Can I make that happen programatically?

Thanks in advance for any help on this one.

James

So show/hide the phone number/e-mail or exclude the person? If you
want to exclude the person, just filter out the "No" records. If you
do want to show the name, but no e-mail or no phone, you could either
create a query and base the report on it, or you could create unbound
controls on your report that did the calculations for you... the
calculations would be the same IIF stuff...