Hello All,
I tried using the following in the criteria section of the NO_ACCESSS column which did not yield the desired results. I am not familiar with SQL so I tried to accomplish this using the expression builder, any help would be greatly appreciated!
What I need the query to do is look at the value of a form if
the level_ID=1 then show all records in query otherwise only display records where No_access is equal to false.
Here is the SQL statement for reference
I tried using the following in the criteria section of the NO_ACCESSS column which did not yield the desired results. I am not familiar with SQL so I tried to accomplish this using the expression builder, any help would be greatly appreciated!
Code:
IIF (FORM!MAIN!LEVEL_ID=1, Like ("*"), False)
What I need the query to do is look at the value of a form if
the level_ID=1 then show all records in query otherwise only display records where No_access is equal to false.
Here is the SQL statement for reference
Code:
SELECT L_VAULT_TBL.STORE_ID, L_VAULT_TBL.ID, L_VAULT_TBL.DESCRIPTION, L_VAULT_TBL.ACCOUNT_NUM, L_VAULT_TBL.WEB_ADDRESS, L_VAULT_TBL.NO_ACCESSS
FROM L_VAULT_TBL;