Transfering Data from one Table to another

[OC2]

Hi,

This is my situation, if you can help ill be very grateful,

this is what ive done so far,

I have a macro that imports an excel file into "import" table. This data is imported once daily and thus the table needs to be empty each day, On my form when I confirm the data using a yes/no text box it updates to a another table "daily report table" which is used to illustrate the data for the current day's records and then printed for filing. Now this i have managed to do.

Here are the problems i have and need help solving,

when I confirm a record, currently, it is just copied to the report table. I need it to be transfered ie removed from one table and pasted to the other.
this data would then print out a record for that day, then moved to the storage table where the records are kept for future refference. Once the proceedure is done, only the storage table should have the records in it, the other 2 tables are blank.




import table ------->Report table------>storage table
l I
l I
print report For reference



can any one help pls,

 

[JerryDennison]

This is a very poor method of controlling your data. Why not simply import into a single table and "flag" each record when the specific task has been performed. Or, probably better still, simply set your queries to report on only those records for the specific time frame needed?