If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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... |
|
Thread Tools | |
Display Modes | |
|
|