I am confused.
I am working with addresses and producing a directory through a series of
reports.
One person would like their name in the directory but not any of their
contact details. In an effort to record this, I created a yes/no field for
privacy.
What I want to know is how I code the query (that my report will use) so
that when this privacy field is "yes", the contact details for that
particular record won't show.
How do I do this??? Or is there a better/easier way to do this than using a
yes/no field?
Kat,
Using a Yes/No field like this is not a bad way of going about it.
Construct calculated fields in the query like this...
ReportAddress: IIf([Privacy],Null,[Address])
ReportPhone: IIf([Privacy],Null,[Phone])

Signature
Steve Schapel, Microsoft Access MVP
> I am confused.
>
[quoted text clipped - 11 lines]
> How do I do this??? Or is there a better/easier way to do this than using a
> yes/no field?
missinglinq - 13 Jan 2007 13:58 GMT
I just HAVE to ask; what's the point in being listed in a "directory" if no
contact information is given?

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000