create table based on two tables.

[brigid]

I have two tables, some of the fields are the same in
both tables. I would like to create a table that shows
the common field, and which includes data from both
tables. Any ideas? Thanks!

 

[tina]

it's possible your two tables should be only one table, to begin with. but
nobody can say, without seeing a description. suggest you post a description
of your existing tables (and explain what data the "common" fields hold), as

tblNameOne
FieldName
FieldName
FieldName
etc

tblNameTwo
FieldName
etc

 

[Jeff Boyce]

Brigid

As Tina points out, we don't really have a lot to go on here. As an aside,
you don't really need/want to create a table that contains values found in
other tables, at least not when you're using Access. If you need the data
from the two table, and the two are related via at least one field, use a
query to pull together the pieces you want from both.