exclude field in query

[chrisy]

I need to create an access query for a directory.
In the database I ask question yes/no if they want their phone # excluded in the directory listing.
How or what is the best way to do this? formula..etc

[Toyman]

I need to create an access query for a directory.
In the database I ask question yes/no if they want their phone # excluded in the directory listing.
How or what is the best way to do this? formula..etc

Create a new column in the query. Place the following:
sPhone: IIf(YourYesNoField=True, YourPhoneField, "")

Using the IIf function, the field will list the phone no if the "yes" is chosen and a blank if "no" is chosen

[chrisy]

Create a new column in the query. Place the following:
sPhone: IIf(YourYesNoField=True, YourPhoneField, "")

Using the IIf function, the field will list the phone no if the "yes" is chosen and a blank if "no" is chosen

Think I am on the right track but had to use false. I haven't used Access alot so I am stumbling through this. Thanks!