export records

[dazedconfusion]

i have a table that has customer's purchase orders along with a yes/no field when a purchase order is marked is closed. I want that record to export to another table that i named Closed Orders

Help i don't know how to accomplish this.

 

[Kevin3NF]

You would accomplish this by setting up an exact copy of the first table,
and appending the closed records to that table (see Append Query in Help),
and once that is confirmed to have worked, you then delete them from the
Original table.

I generally discourage this type of activity. Setting the Yes/No flag is
generally sufficient unless you have a huge amount of orders and performance
is slowing down.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

i have a table that has customer's purchase orders along with a yes/no

field when a purchase order is marked is closed. I want that record to
export to another table that i named Closed Orders.