A Windows 98 & ME forum. Win98banter

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.

Go Back   Home » Win98banter forum » Windows 98 » Software & Applications
Site Map Home Authors List Search Today's Posts Mark Forums Read Web Partners

Access Query



 
 
Thread Tools Display Modes
  #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
  #2  
Old June 23rd 11, 02:33 PM posted to microsoft.public.win98.apps
98 Guy
External Usenet User
 
Posts: 2,951
Default 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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Mike M Printing 0 March 5th 08 06:43 PM
QUERY Capt K Ripendran General 5 January 8th 06 04:39 PM
QUERY Capt K Ripendran Monitors & Displays 4 January 12th 05 04: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


All times are GMT +1. The time now is 12:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Win98banter.
The comments are property of their posters.