Filltering my results in a Querie

Y

Yiannis

Hi i'm new to db's so, if anyone can guide me in the right direction
here i'll apretiate any help i can get.
i have a table with a product feild, a product type feild, and a
product storage feild. The last 2 feilds have a lookup wizerd with set
values.i wana make a querie and be able to filter the results based on
the value i chose in the lookup wizard how will i be able to do that?
Thanks in advance John
 
J

John Vinson

Hi i'm new to db's so, if anyone can guide me in the right direction
here i'll apretiate any help i can get.
i have a table with a product feild, a product type feild, and a
product storage feild. The last 2 feilds have a lookup wizerd with set
values.i wana make a querie and be able to filter the results based on
the value i chose in the lookup wizard how will i be able to do that?
Thanks in advance John

You might want to consider ditching Microsoft's misdesigned,
misleading, and very limited Lookup Wizard. See

http://www.mvps.org/access/lookupfields.htm

for a critique.

This is one of the things the lookup wizard isn't smart enough to
handle. What you *can* do is to create a Query joining the main table
to the two lookup tables; this will give you the lookup table text
fields instead of the (concealed) ID, and you'll be able to put
crieteria on these fields.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top