HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 05:34
- Joined
- Apr 1, 2019
- Messages
- 731
People, this may sound silly. I have a select query that I wish to return the records for either that user (if level 1) or all users (as for a supervisor) if not level 1. I've tried various permutations of
IIf(getuserlevel()=1,getusername(),"*") in the select criteria of the "Username" field. It works for user level 1 and returns those records, but will not return any records if user level is not =1 (as in a "supervisors"security.
Both GetUserLevel() & GetUserName() are subroutines that work elsewhere.
What's wrong?
IIf(getuserlevel()=1,getusername(),"*") in the select criteria of the "Username" field. It works for user level 1 and returns those records, but will not return any records if user level is not =1 (as in a "supervisors"security.
Both GetUserLevel() & GetUserName() are subroutines that work elsewhere.
What's wrong?