By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,255 Members | 1,701 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,255 IT Pros & Developers. It's quick & easy.

Restrict data that users view in multiuser environment

P: 1
I have a Timekeeping Database that will be used by the Time Keepers
in various departments. I want to restrict view of the data of one
department from the other department. I created seperate query for
each department. I have idea about the workgroup and currentuser
function. But I don't know where to apply currentuser function.
How would I go about doing that. Any help or example given is
apprecited very much.
Oct 6 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

To check your user

Res:IIF(Currentuser()="1", True, False)

as criteria under this column you type True

And the result is that those records are shown for user "1"

Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.