Easy question for you guys

wjmjr

New member
Local time
Today, 07:08
Joined
Jul 14, 2005
Messages
7
:mad: I need some quick help

I have a db with multiple tables. I have 15 queries that look up open audit obsrevations depending on the name.
I'm trying to limit the number of queries that I need to validate. Is there a way to create one query that has a lookup fied or Key word field.

Thanks in advance

-WM
 
Yes. A parameter query can prompt you for a value when it runs. Another option is for the query to get its variable values from an open form:
1. Select .... From ... Where SomeField = [enter a value];
2. Select .... From ... Where SomeField = Forms!YourForm!SomeField;
 
Pat
I used you first option it works great but I have one more issue...
The field I'm looking up is a name field. When I enter a value ie (Warner) I get all the audit observations. (perfect)
However some observations are given to multiple people ie (Warner/Cinder). When I run the query I'm missing the rows which contain multiple names.
Can I use a wild card character or
Select...From... Where SomeField = [enter a value] [ / ] to get all the values

-WM
 
The correct solution to your problem is to fix the table structure to remove the non-atomic attribute that contains a repeating group. When you have a 1-many relationship, the "many" data belongs in a separate table. Search for posts on normalization.

For the time being you can use the Like operator and wildcards to retrieve all entries.

Select...From... Where SomeField Like "*" & [enter a value] & "*"
 

Users who are viewing this thread

Back
Top Bottom