Q: show value if another field is yes

[Guest]

In a query, I want to display the value in a field if another permission
field is yes.
Ex: I want to display the email values in a list if the permission is yes.

 

[Michel Walsh]

Hi,


SELECT iif(permission, address, null) , ... WITH OWNERACCESS OPTION;



I added with owner access security, since it is likely that you will NOT
allow the typical user to WRITE his/her own query, neither to explore the
table with their own permissions defined by the security.


Hoping it may help,
Vanderghast, Access MVP