If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query | Mike M | Printing | 0 | March 5th 08 05:43 PM |
QUERY | Capt K Ripendran | General | 5 | January 8th 06 03:39 PM |
QUERY | Capt K Ripendran | Monitors & Displays | 4 | January 12th 05 03:11 PM |
query | prabin biswal | Software & Applications | 2 | August 20th 04 08:54 AM |
access query display text field as barcode | Warren | Improving Performance | 0 | May 31st 04 03:41 PM |