Copy records from query, paste into DB help...Thanks

[Taran72]

I have created a query to display certain records from a database, and sort them. I want to be able copy these records from this query and OVERWRITE the records in the original DB. I want to effectively move these queried records to the top of the original DB. However, PASTE APPEND is not working, and just adds the records to the DB without overwriting. I do not mind doing it manually, I just want to make sure the records are at the top of the DB, and does not duplicate.
Any suggestions?

This site (and it's users) is awesome.

Dan

 

[Lightning]

1 You are using a query to sort the records in a table
2 You want to then save the query results as the table
3 You are not changing the data in the original table, only the sort order

Is my understanding of what you are trying to do correct?

If so, can you not just change the index of the table to sort in the required order?

If not, then you could try this:

1 Convert your query to a Make-Table query, saving your data as a different table name.
2 Use the TableDef collection to rename your sorted data to the original table name.

HTH
Lightning

 

[Taran72]

Duh...I figured it out (Just "PASTE"!!)...thanks anyway.

Dan