Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2007

Tip: Looking for answers? Try searching our database.

How do I create    If "yes" then address for that record will not

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kat - 12 Jan 2007 07:48 GMT
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?
Steve Schapel - 12 Jan 2007 08:36 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.