Merging two tables

  • Thread starter Thread starter Karan
  • Start date Start date
K

Karan

Hi,

I have two tables Called SalesBilling & TradeBilling

Both the Table's structures are same in all the fields and Data Types.
Because of these two bills have different Bill Numbers i made them in Two
Tables.

for example: Sales Billing Starts with 1, 2, 3, ........
Trade Billing Starts with 1001, 1002, 1003, ..........

Now i want to merge the Two Tables and sort out according to Dates.

Can this be done? for the time being i am exporting both the tables to
excel and copy paste both the data in one sheet and sorting out by dates.
which looks like (only Bill No. Field) 1, 2, 1001, 3, 4, 5, 1002, 1003, 6,
................

I tried to do by Query, but failed.

Any help will be highly valued.

Thanks and Regards

Karan.
 
Karan said:
Hi,

I have two tables Called SalesBilling & TradeBilling

Both the Table's structures are same in all the fields and Data Types.
Because of these two bills have different Bill Numbers i made them in Two
Tables.

for example: Sales Billing Starts with 1, 2, 3, ........
Trade Billing Starts with 1001, 1002, 1003, ..........

Now i want to merge the Two Tables and sort out according to Dates.

Can this be done? for the time being i am exporting both the tables to
excel and copy paste both the data in one sheet and sorting out by dates.
which looks like (only Bill No. Field) 1, 2, 1001, 3, 4, 5, 1002, 1003, 6,
...............

I tried to do by Query, but failed.

Any help will be highly valued.

Thanks and Regards

Karan.
Click to expand...

You should be able to do want you want using an Append Query.
Make sure you put all the fields you want copied into the query in design
view, and
look at it in datasheet view before running it to see if it is doing what
you want.

David
 
Mr. David Mann,

Thanks a lot for the help. I am able to Append the tables i want and it
works fine.

Can i do the following - Please Suggest.

1). If i need to append three tables at a time, do i need to create the
three different Append Query or I can do this at one Append Query with the
selection of Three Tables.

2). I want to know, once the data is copied to the destination table, it
looks perfect. But, When i enter new records in a table and then perform
the action of Append Query,
a). Will it Copy only the New Records
b). Will it Copy All the Records
c). Or I need to Re-Create Append Query everytime i add new records.

3). Is there anyway i can run this Append Query(s) when i open the database
(or) at a particular time schedule.

Can you clarify this things.

Thanks and have a nice day !!

Karan.
 
Karan said:
Mr. David Mann,

Thanks a lot for the help. I am able to Append the tables i want and it
works fine.

Can i do the following - Please Suggest.

1). If i need to append three tables at a time, do i need to create the
three different Append Query or I can do this at one Append Query with the
selection of Three Tables.

2). I want to know, once the data is copied to the destination table, it
looks perfect. But, When i enter new records in a table and then perform
the action of Append Query,
a). Will it Copy only the New Records
b). Will it Copy All the Records
c). Or I need to Re-Create Append Query everytime i add new records.

3). Is there anyway i can run this Append Query(s) when i open the database
(or) at a particular time schedule.

Can you clarify this things.

Thanks and have a nice day !!

Karan.
Click to expand...
Hi Karan,

I think Pieter answered your question.
But fell free to ask again if necessary. :-))

David
 
Back
Top