Criteria using values from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm triyng to build a criteria the load the values from a table.

Imagine that in my table I have the colum Codes, and I have 3 records in
that table.

the records values are 3; 10; 15

I would like to create a criteria that reads the table values and use it as
the criteria, so my criteria would be 3; 10; 15.

Regards,
Marco
 
Use an inner join.

Bring your data table and your 'criteria values' table in a new query. Join
the field of the data table to the field of the criteria values table. In
the grid, drag the fields you want to see from the data table.

That's all.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top