Query's

  • Thread starter Thread starter Adam mellor
  • Start date Start date
A

Adam mellor

I have a Customer Complaints database, where a number of
people in my company add to it. I was wandering if there
is anyway that i could set up a lookup table inside a
query "parameter value" search, so that you can choose
from the list what you want to search for, for
example "complaint type" is the table i am creating the
query on we have 6 different types of complaint, this
lookup should contain all 6 of the complaints for the user
to choose from.

Hopefully i have made myself clear as to what i require.

I would apprieciate any help on this problem
 
Adam,

This cannot be done in a parameter query. However, you could create a
form that has a combo box on it that contains the various complaint
types. Then, modify your query so that it references the value in the
combo box in its criteria.

--
HTH

Dale Fye


I have a Customer Complaints database, where a number of
people in my company add to it. I was wandering if there
is anyway that i could set up a lookup table inside a
query "parameter value" search, so that you can choose
from the list what you want to search for, for
example "complaint type" is the table i am creating the
query on we have 6 different types of complaint, this
lookup should contain all 6 of the complaints for the user
to choose from.

Hopefully i have made myself clear as to what i require.

I would apprieciate any help on this problem
 
Back
Top