how do i make a table from two other tables?

[Guest]

I have two tables, each with an ID column that contains a 5 digit number.
Table A has ID's that are not in Table B, and Table B contains all the ID's
in table A plus more. I want to create a table with the information from
Table A, combined with the info from Table B but only that which corresponds
to the ID's in Table A. How do I do this?

Thank you, I am extremely frustrated.

 

[Jeff Boyce]

Create a new query. Add TableA and TableB. Join them on the ID field. Add
the fields from TableB that you wish to see.

You will only see the data for those rows where the ID in A matches the ID
in B.

(Why do you need to create another table, when you have the query results?)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

It keeps telling me I need at least one destination field.

 

[Jeff Boyce]

If you don't select at least one field for the query to output, it has
nothing to show.

Regards

Jeff Boyce
Microsoft Office/Access MVP