Move Table Info And Delete

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a main table for new charges which havnt been billed which is
called tblNewcharges which has the following

ClaimID(pk)AutoNumber
PersonID
DateOfServiceFrom
DateOfServiceTo
DateBilled


What I want to do is wright a query that when i press a command button
lets say start will move all the info in the tblNewcharges and put
them in to a table called tblclaimsfiled then delete the info stored
in the tblNewcharges.


Also is it possible to put the date in the date billed field when the
query is run.




Thanks,

.

Quantcast