Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page