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
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
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!