R
Richard Horne
Hi I have a query which collects the data I require for a particular process,
how do i then copy the results of this query into a new table with an
identical field layout? Basically I need two copies of each set of results.
I am creating an ordering system and the details I query are orders placed,
but I need to then copy the results of the query into a new table -
deliveries so that I can then print a delivery note. The reason I need two
copies is that one is for a record of each order and the second is a record
of what was sent in each delivery.
Table = Order_Details
===============
Orders_ID
Item_Number
Item_Type
Description
Quantity
Denomination
Table = Delivery_Details
=================
Same fields as above.
how do i then copy the results of this query into a new table with an
identical field layout? Basically I need two copies of each set of results.
I am creating an ordering system and the details I query are orders placed,
but I need to then copy the results of the query into a new table -
deliveries so that I can then print a delivery note. The reason I need two
copies is that one is for a record of each order and the second is a record
of what was sent in each delivery.
Table = Order_Details
===============
Orders_ID
Item_Number
Item_Type
Description
Quantity
Denomination
Table = Delivery_Details
=================
Same fields as above.