Joining two tables

[Eddie Mason]

I have two tables both containing orders the first is an Access table with historic data and the second is a linked SQL table (which has replaced the old Access DB) with all the new orders. What I want to do is create a query which shows all the orders both old and new so that I can get various statistical reports. I realise that this could be done by creating a separate table and appending both sets of records to it, this however would result in the table not being dynamic and not automatically adding records as they created in the SQL DB.

Can anyone give me advice?

Kind regards,

Eddie

 

[CJ_London]

You should be be able to use a union query to link your two tables together.

Here is a link for more information about union queries

http://office.microsoft.com/en-gb/a...eries-by-using-a-union-query-HA010206109.aspx

 

[Eddie Mason]

Hi CJ,

Many thanks for the advice, I'm now up and running, you’ve been a great help.

Kind regards,

Eddie