Filltering my results in a Querie

  • Thread starter Thread starter Yiannis
  • Start date Start date
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
 
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
Click to expand...

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]
 
Back
Top