How to update multiple table contents into 1 table in MS Access 2010

[saryan]

Hello,

I am new to this site, and new to Access as well, i have 3 different tables in my access wherein i have to insert those 3 tables contents into a master table on daily basis. please help me with this query as how can i do this.

Date	Total Globe	AP	EMEA	NA	LA
5/1/2013	2000	500	500	500	500

<tbody>
</tbody>

Date	Total NA	Canada	ITO	NBD	SBD
5/1/2013	4000	1000	1000	1000	1000

<tbody>
</tbody>

Vendor-Total Globe	Vendor-AP	Vendor-NA	Vendor-EMEA	Vendor-LA
200	100	100	100	100

<tbody>
</tbody>

i have 3 tables with with different columns like mentioned above the only matching column would be on all these 3 tables is date column (nothing but current date). so all these 3 tables need to be updated into the master table on daily basis the only criteria would be the date check , in the Master table there is only one date column . and then different regions in other columns.please see the master table format shown below, in access i have created the table in the exact format.

Date	Total Globe	Asia Pacific	EMEA	Latin America	North America	Total North America	Canada	ITO	NBD	SBD	Vendor-Total Globe	Vendor-Asia Pacific	Vendor-EMEA	Vendor-Latin America	Vendor-North America
5/1/2013	2000	500	500	500	500	4000	1000	1000	1000	1000	200	100	200	400	600

<tbody>
</tbody>

Some one please help me on this.
Regards,

 

[saryan]

Re: Need help to get MS Access query to update multiple table contents into 1 table in MS Access 2010

Is there anybody in the forum , who can help me on this to get a MS Access query to perform the activity which i have mentioned in my post !!!