If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create table based on two tables.
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! |
#2
|
|||
|
|||
create table based on two tables.
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 "brigid" wrote in message ... 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! |
#3
|
|||
|
|||
create table based on two tables.
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. -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|