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 |
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 04:04 AM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Win98Banter.com