By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

combining info from two identical tables into one

P: 2
I have a table on one computer and another table, same table info from different time frames, and I don't know how to combine the two into to one table. Using microsoft access.
Sep 8 '06 #1
Share this Question
Share on Google+
6 Replies


PEB
Expert 100+
P: 1,418
PEB
You need :

to attach the one of the tables into the database of the other and create a query
that is named append query

You can select this option from the menu Query / Append query

And then assign in which field of the appended query you will add the fields of the choosen query

If you aren't experimented with this kind of queries try with two tables that are samples! With no important data inside! It's better the sample tables to be with the same structure! :)
Sep 8 '06 #2

ADezii
Expert 5K+
P: 8,607
I have a table on one computer and another table, same table info from different time frames, and I don't know how to combine the two into to one table. Using microsoft access.
How about trying a UNION Query?
ADezii
Sep 8 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Oh! Sorry I thought to transfer data! If not the Union is the best solution! :)
Sep 8 '06 #4

P: 2
The main user wants to see all the info in ther form view. Will the form view combine the tables?



You need :

to attach the one of the tables into the database of the other and create a query
that is named append query

You can select this option from the menu Query / Append query

And then assign in which field of the appended query you will add the fields of the choosen query

If you aren't experimented with this kind of queries try with two tables that are samples! With no important data inside! It's better the sample tables to be with the same structure! :)
Sep 8 '06 #5

PEB
Expert 100+
P: 1,418
PEB
After Using An union Query you can visualize the information in Form View but you can't Add or edit it!

So the recordset isn't updatable!
Sep 8 '06 #6

PEB
Expert 100+
P: 1,418
PEB
To do an Union QUERY you have to attach to the main database the suborinated database

Than

Create a new query in SQL View

SELECT * FROM My_Table UNION SELECT * FROM My_Table1;

And Name it my_union

It will show you the information from the both tables!
Sep 8 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.