How to Query list of criteria

[PAD]

I'm very new to access - perhaps this is an easy one...

I have a master table 2 columns wide. I want to extract data from the master table for values that appear in a second table.

That is...
Master Table:
1 a
1 b
3 c
4 d
4 e
6 f
6 g
5 a

My second table

1
6
5

I want to return:

1 a
1 b
6 f
6 g
5 a

I basically want to enter a list of values in the criteria section of the query design view.

Any suggestions?

 

[EMP]

I basically want to enter a list of values in the criteria section of the query design view.

Since the values are in the second table, you don't need to put them in the criteria.

You can add the second table to the query in query design view. Then link the two tables by dragging the numeric field from the master table to the numeric field of the second table. Access will draw a line joining the two fields.

^