Copy table row data to same table

[Tcurtis]

I have a question about copying data to the same table. I have a table that is imported each day. Sometimes the data has a quantity of 2 instead of 1 when a shipment is received. I would like to split that data into two rows in my table, each with unique Key numbers. The query to find these is simple enough but I need to have each item as a unique number in my database.

Thanks

 

[Joe4]

Just use an Autonumber field. That will automatically assign a unique number to each record. You don't even have to tell it to do so, it will do it automatically.
You can use an Append Query to add your new row, and an Update Query to update the existing row (change the 2 to 1).