combine two unlike tables

[Ryan Proudfit]

I'm trying to combine two unlike tables, and I'm running into trouble. I've
never done this before so I have no idea what I'm doing. I've added the
columns from table #2 to table #1, then copied table #2 from the database
window, opened table #1 and tried to do a paste append. It didn't work.
Please help.

 

[David Seeto via AccessMonster.com]

By "combine two tables", it sounds like you want table #3 to have the
columns from table #1 and table #2 and that they have a column in common -
it would help if you could post the names of the columns of both tables.

In any case, I think what you're after is a Query that joins the two tables
together on the common column. Post again if you need help with this.