Win98banter

Win98banter (http://www.win98banter.com/index.php)
-   Software & Applications (http://www.win98banter.com/forumdisplay.php?f=4)
-   -   Access Query (http://www.win98banter.com/showthread.php?t=50847)

Anthony June 22nd 11 08:50 PM

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

98 Guy June 23rd 11 02:33 PM

Access Query
 
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.


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Win98Banter.com