Want to combine two tables into one table

[Confused real estate broker]

Using Access 2000, I have two tables that I need to
combine into one table. Each table has one field with
information common to both tables. I have not used access
much before and don't have a clue where to begin. Can
anybody help?

 

[Dan Barnes]

I'm not an expert, but your question seems simple so I'll
take a stab at it.
1. Create a new 'Make Table' query
2. Add your two tables to the query
3. Establish a relationship between the common fields
4. Drag the fields into the query grid
5. Run the query

Hope this helps!