Saving the results of a query into a new table?

[Guest]

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.

 

[Guest]

a suggestion.
making a new table for each delivery note will make your
db grow in size.
I would put the query in a single table as a new record
with an append query with a Order Number(?) to id the
records.
I would create a select query(selecting the same thing as
the append query) and use it as a record source of a
report to print the delivery note for the record.
the print and append new record could be done togeather
with code. a one click operation.

 

[Guest]

Hi I realise this is not quite the optimal way of doing this but my delivery
system is getting very complicatd and difficult to manage.

I have two tables Orders and Order_Details - Orders contains all the info
for an order such as invoice name and address, delivery and address, order
number etc etc. Order_Details contains info on all items ordered. These
tables are linked by a field called Orders_ID

I now need to create a delivery system whereby the user would type in the
Order_ID followed by the Item Number followed by the quantity. This could be
done multiple times for any one order - meaning there can be multiple items
on one delivery note. So i need a note to refer to the Order Details but also
multiple items - but here's the important thing. Not necessarily every single
item for that order. Somehow I need to be able to select which items for each
order belong on the delivery note.

I started to create a system where I had Orders and Order_Details as above
as well as Deliveries and Delivery_Details however this seems to get really
complicated - what with all the relationships and doesn't seem to work for
me. E.g A form called Deliveries will need to refer to Orders, Order_Details
and Delivery_Details. Really messes with my head.

Any suggestions how best to do this? :S