Leave out Some Data

[Phillip Schmidt]

Hey All,

I have a table of contact information (name, address,
phone, email) and some people have opted to not have their
information listed, but I need to show their name. Is
thier a way that I can create a report, and not display
the text in certain fields (those of a private nature when
they have choses "Do Not Publish").

Thanks

 

[Marshall Barton]

I have a table of contact information (name, address,
phone, email) and some people have opted to not have their
information listed, but I need to show their name. Is
thier a way that I can create a report, and not display
the text in certain fields (those of a private nature when
they have choses "Do Not Publish").

Here's one way. Create a query based on the contacts table.
For each ield that should not be printed, cange the field to
an expression along these lines:

ShowAddress: IIf(publishfield, address, Null)

 

[Marshall Barton]

Please keep the correspondence in the newsgroups. Private
consulting is reserved for paying clients.

If your field is True when the data should be hidden, then
reverse the values in the IIf:

IIf([NoPublish], Null, [Address])