How do I create a query from a look up column?

  • Thread starter Thread starter pMs
  • Start date Start date
P

pMs

I am trying to create a query using a column where I used the look up feature
to create the data. Is there a way to do this? I have specific course dates
listed but now when I try to create a query using those dates it does not
work. Thanks
 
I am trying to create a query using a column where I used the look up feature
to create the data. Is there a way to do this? I have specific course dates
listed but now when I try to create a query using those dates it does not
work. Thanks
Click to expand...

The Lookup Wizard is very, very limited, and many folks consider it a
misfeature:

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

has a critique.

What you can do is open the table in design view, select this field, and
choose the Lookup tab on the lower left. Note the name of the lookup table.

Now create a new query; add your main table and the lookup table to the design
window. Access should automatically join them.

Now you have a query with both tables, and you can select and apply criteria
or sorts to any field from either table.
 
Back
Top