Append Query but duplicate records

[mugen_rsx]

I spend a lot of time seaching here, but not sure what to look for, please help!!


I have two linked tables

One has
Order_Number
Client
(and other info)

The Other one has
Order_ID
Order_Number (link with first table)
Finish (user choose it is "processing" or "done")
(and other info)


I am doing a append qury here. I want to move are "done" order to another table. I am having problem doing it with the first table because Order_Number duplicate.

How can I display only once of the "Order_Number"? Thank you

 

[steallan]

Hi

I think you first want to use a select query to get all the records with "done" in them. Run this just on the table with this data in.

Then use a create table query on this select query to make a table.

then use an append query on this new table to add the data to another table

dead easy eh