NOT printing certain fields in a report

[papabill]

I'm trying to construct a small, simple Church Member Directory database, and have found answers to most of my problems. However, I still have one challenge I cannot overcome.



I'm taking information (Names, addresses, phone numbers, birthdays, wedding anniversaries, etc.) from all the members. This includes the minor children of our members. When I print the directory, I don't want the phone number, email, and wedding anniversary fields to even show. So far the ONLY way I can figure out how to do it is to make separate reports from each of the groups of members (seniors, widows/widowers, married couples, teens, and minor children.)

Is there ANY way that these fields can be omitted at the query level?

I've asked this in several other forums, but all I'm told is to read the Access help files. (Already done that!!)

Thanks

[ranman256]

Yes, 1 query for all info.
1 query for some info.

[rpeare]

That's a rather heavy handed approach.

If your goal is to not print the information for minors you can figure their age from their date of birth and set the value to null

so your age calculation would be something like

Age: IIf(Format([birthdate],"mmdd")>=Format(Date(),"mmdd"),0,-1)+DateDiff("yyyy",[birthdate],Date())

Then you can test the age to show or not show other pieces of data like

Address1Conv: iif(age <=18, null, [Address1])

Or you can do it with conditional formatting on the report itself.