Cut record from a table instead of appending

[CAM]

Hello,

I have two tables call "monthAudits" and another "Upload" I get select
policy numbers from the monthAudits and append the policy number into the
Upload table, which works fine, but what I really want to do is to take the
selected policy numbers from the monthAudits table and put it into the
Upload table. I don't want to append to the Upload table I just want to cut
the policy number from the monthAudits table and paste it to the Upload
table. There are maybe about 20 or more records. I just want to reduce the
size of the monthAudits table and get only the records I want and put it
into the Upload table. Can someone give me a hand on this. Thank you in
advance.

 

[John Vinson]

Hello,

I have two tables call "monthAudits" and another "Upload" I get select
policy numbers from the monthAudits and append the policy number into the
Upload table, which works fine, but what I really want to do is to take the
selected policy numbers from the monthAudits table and put it into the
Upload table. I don't want to append to the Upload table I just want to cut
the policy number from the monthAudits table and paste it to the Upload
table. There are maybe about 20 or more records. I just want to reduce the
size of the monthAudits table and get only the records I want and put it
into the Upload table. Can someone give me a hand on this. Thank you in
advance.

Ummm...

Why should the Upload table exist at all?

You can export (for uploading) from a Select Query selecting the 20
records from the monthAudits table, and not make a second copy of the
data in the first place.

If you *do* want to do so, you'll need to run an Append query to add
the records, followed by a Delete query to remove them; these two
queries should be wrapped in a Transaction (see the online help for
the term) to ensure that both queries run, or both get rolled back.


John W. Vinson[MVP]