Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Queries > Switch Function
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 41200 of 43104
Post > Topic >>

Switch Function

by =?Utf-8?B?SGFydmFyZA==?= <Harvard@[EMAIL PROTECTED] > Aug 6, 2008 at 09:06 AM

I'm trying to create a query that returns only the records of the current 
user.  I've decided to use a switch function.  And it appears to be
working.  
My only problem is that I don't know how to get the switch to return
multiple 
values.  If I log on as admin, i want to be able to see all user
information. 
 Here's what I have.  Can someone give me a hand?

Switch(CurrentUser()="admin","admin" And 
"hjames",CurrentUser()="hjames","hjames")
 




 6 Posts in Topic:
Switch Function
=?Utf-8?B?SGFydmFyZA==?=   2008-08-06 09:06:01 
Re: Switch Function
"Michel Walsh"   2008-08-06 13:32:56 
Re: Switch Function
=?Utf-8?B?SGFydmFyZA==?=   2008-08-06 11:41:11 
Re: Switch Function
"Michel Walsh"   2008-08-06 14:57:55 
Re: Switch Function
=?Utf-8?B?SGFydmFyZA==?=   2008-08-06 13:42:01 
Re: Switch Function
"Michel Walsh"   2008-08-07 06:39:56 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 19:25:02 CST 2008.