Leave out Some Data

  • Thread starter Thread starter Phillip Schmidt
  • Start date Start date
P

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
 
Phillip said:
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").
Click to expand...


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)
 
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])
 
Back
Top