Adding all records from one table to another

[PB90]

I know this should be easy, but I'm tired & hitting a wall. I have One table I add to and then after all checking is done, if there are any records in that table I want to copy them all to another table.
How can I do this?

 

[Remou]

Hi
Is there any reason why you cannot use an append query?

 

[PHV]

Have a look at append query:
INSERT INTO ... SELECT ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886