Thread: Access Query
View Single Post
  #1  
Old June 22nd 11, 08:50 PM posted to microsoft.public.win98.apps
Anthony
external usenet poster
 
Posts: 1
Default Access Query

I have a query that pulls data from a few linked tables. In my query I
inserted and field not linked to any tables called "Supervisor
Password" in the criteria, I write the expression that will allow only
certain words (="test1" Or "test2" Or "test3"...)
Now I have another field that is linked to the tables called
[Department]
in the criteria I write =IIf([Supervisor
Password]="test1","1020",IIf([Supervisor Password]="test2","2010","Not
a valid password") this all works fine and dandy.

The problem is... I need to be able to pull up more than one
department using the same password because our supervisors are in
charge of several departments.

When I write the expression that I think will work I write
=IIf([Supervisor Password]="test1","1020" And 1030",IIf([Supervisor
Password]="test2","2010" And "2030",IIf([Supervisor
Password]="test3","3010" And "3030""Not a valid password")
I have also tried it like so... =IIf([Supervisor
Password]="test1","1020" & "1030",IIf([Supervisor
Password]="test2","2010" & "2030",IIf([Supervisor
Password]="test3","3010" & "3030""Not a valid password")

As well as...
=IIf([Supervisor Password]="test1","10**",IIf([Supervisor
Password]="test2","20**",IIf([Supervisor Password]="test3","30**","Not
a valid password") and nothing works.

any help is appreciated.
Anthony