Q: show value if another field is yes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top