Re: Cut record from a table instead of appending
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 29 Aug 2006 14:42:38 -0600
On Mon, 28 Aug 2006 23:37:00 -0700, "CAM" <alex_martinez@xxxxxxxxxxx>
wrote:
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]
.
- References:
- Prev by Date: Re: basic query help for two linked tables
- Next by Date: Re: Auto-populate one table from another
- Previous by thread: Cut record from a table instead of appending
- Next by thread: Re: comparing rows in a query
- Index(es):
Relevant Pages
|
