Move Table Info And Delete

[jeremy0028]

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,

 

[kingston via AccessMonster.com]

You can do this with two queries: Append and Delete.

The append query would add the data from tblNewcharges into tblclaimsfiled,
and the delete query would delete the records from tblNewcharges. Build
these queries visually and then you can create a button that runs them with
DoCmd.OpenQuery ...

In the append query, simply add a new column and use the function Date() to
set the new field. You probably should add some error checking to ensure
that the append query worked before running the delete query, but this should
get you started.