Criteria for Query

  • Thread starter Thread starter Bill Hartnelll
  • Start date Start date
B

Bill Hartnelll

Is it possible to use a table or query as critera to
create another query? What I want to do is use a table of
local offices to pull information from a table that has
information on all offices. I would prefer to use the
table but I do have a query that lists the offices I need.


Thank You
 
Is it possible to use a table or query as critera to
create another query? What I want to do is use a table of
local offices to pull information from a table that has
information on all offices. I would prefer to use the
table but I do have a query that lists the offices I need.
Click to expand...

You can't use a Table as a criterion - a Table has up to 255 fields
and up to millions of rows, so it doesn't have "a value" that you can
use as a criterion!

Instead, use Access as it is designed: a relational database. Create a
Query joining this Offices table to your LocalOffices table. Only
those which match will be displayed.
 
Back
Top