Access Query

[Anthony]

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

[98 Guy]

Anthony wrote:

> I have a query that pulls data from a few linked tables.

This looks like SQL or MS-Access data base stuff.

> any help is appreciated.

Can you explain why you posted this to a Windows-98 newsgroup?

Yours is the first post here in this group in maybe a year or two.

It's way off topic. And you're question can't really be answered
without seeing how your database is constructed or organized.