question regarding tables consolidation

[una]

Hello everyone.
I have no experience at all with datatabases, but now I have to manage a new
access database with 3 tables A,B and C.

Tables B and C are updated with new data on a daily basis and once a week
all the new data should be exported or consolidated to the table A.

Tha question is: How can I do that?

 

[John Vinson]

Hello everyone.
I have no experience at all with datatabases, but now I have to manage a new
access database with 3 tables A,B and C.

Tables B and C are updated with new data on a daily basis and once a week
all the new data should be exported or consolidated to the table A.

Tha question is: How can I do that?

With Append queries. If you need a more specific answer please post a
more specific question.

Or... better... by redesigning the system so this is not necessary!
Having three different places where the same data might be stored is
emphatically NOT good design. Access is pretty good at sharing data;
why not have TableA updated so that it's always current?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps