Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Wierdest thing ever append querie

Discussion in 'Information Technology' started by Dustin, Nov 8, 2005.

  1. Dustin

    Dustin
    Expand Collapse
    Guest

    hello all
    I am using an append querie to create a new work order based on calculations
    with schedules, and it all works and has for some time. Now all of a sudden
    every time the append querie creates a new record it creates the same record
    twice. and the next time I run it it creates it four times then 8, the most
    frustrating part is this all used to work and I have made no changes, what is
    going on
    --
    Dustin
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Dustin" <Dustin@discussions.microsoft.com> wrote in message
    news:37D40102-895E-4132-AD6A-B46B8BC933FC@microsoft.com
    > hello all
    > I am using an append querie to create a new work order based on
    > calculations with schedules, and it all works and has for some time.
    > Now all of a sudden every time the append querie creates a new record
    > it creates the same record twice. and the next time I run it it
    > creates it four times then 8, the most frustrating part is this all
    > used to work and I have made no changes, what is going on


    This is just a guess, but I suspect that your append query joins two or
    more tables, and one of those tables has two records with the same join
    key. So when you join the tables, you get two output records for each
    input record in the table on the other side of the join.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 7 Nov 2005 14:26:25 -0800, Dustin
    <Dustin@discussions.microsoft.com> wrote:

    >hello all
    >I am using an append querie to create a new work order based on calculations
    >with schedules, and it all works and has for some time. Now all of a sudden
    >every time the append querie creates a new record it creates the same record
    >twice. and the next time I run it it creates it four times then 8, the most
    >frustrating part is this all used to work and I have made no changes, what is
    >going on


    Sounds like you're including the target table as part of the source in
    your query. Don't. It's not necessary (except in very special cases)
    to reference the table that you're writing *to* in the Append query.

    Perhaps you could open the append query in SQL view and post the SQL
    text here if this isn't making sense.

    John W. Vinson[MVP]
     

Share This Page