Criteria using values from a table

[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

 

[Michel Walsh]

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