Query Query
From: Simon Dowse (anonymous_at_discussions.microsoft.com)
Date: 06/29/04
- Next message: Sophisticated Penguin: "Re: Criteria - multiple column table"
- Previous message: Les Mercer: "Make Table query on ODBC table changes NULLs to empty strings in Access 2002"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 02:54:18 -0700
Hi,
I have a form with a load of person data in it. There is
also a link to another which will display extra
information on that person, which is done by a query that
matches the username for the record on the form to a
record in the new form.
The 2nd form displays codes dependant on what user rights
that person has. The user rights are grouped into 3 areas
and I have a table that lists the codes by area. Is there
anyway to have a query lookup a code and then return what
area it falls into? I want the 2nd form to say the code
(which it does) but also what area the code is from.
Any ideas? (Hope this is clear!)
- Next message: Sophisticated Penguin: "Re: Criteria - multiple column table"
- Previous message: Les Mercer: "Make Table query on ODBC table changes NULLs to empty strings in Access 2002"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
