RE: Appending records to source and destination tables

I got it - as usually happens when you ask a question - you keep hacking and
get it. I had copied the table to a new table (right click, save as) and for
some reason this made that happen. When I deleted it manually made the table
and relinked it I stopped having the problem.

"Bonnie" wrote:

> Hi Folks,
>
> Can you please help -I'm running an append query with a problem. Here's
> the SQL in the query:
>
> INSERT INTO Transactions ( ItemNo, DateConsumed, LogOutBy, ItemDescription,
> LogQty )
> SELECT History.ItemNo, History.DateConsumed, History.LogOutBy,
> History.ItemDescription, History.LogQty
> FROM History
> WITH OWNERACCESS OPTION;
>
> The problem is, it appends the whole table to the source table before it
> appends the whole thing to the target table. Can you tell me what I'm doing
> wrong. I know this is a simple task I just don't see what's wrong.
>
> Thanks.
>
.

Relevant Pages

  • Appending records to source and destination tables
    ... Can you please help -I'm running an append query with a problem. ... INSERT INTO Transactions (ItemNo, DateConsumed, LogOutBy, ItemDescription, ... it appends the whole table to the source table before it ...
    (microsoft.public.access.queries)
  • Re: Append Query
    ... A simple (but perhaps not 'elegant') solution is to create two queries: ... that appends to the main table, and one that appends to the related table. ... create an append query and add these fields into both tables at the same ...
    (microsoft.public.access.externaldata)