Welcome to SPN

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

Sign Up Now!

Fast append query question

Discussion in 'Information Technology' started by VisualBasic@versatel.nl, Jul 28, 2006.

  1. VisualBasic@versatel.nl

    VisualBasic@versatel.nl
    Expand Collapse
    Guest

    Hello,

    Does anyone know how to create one or more queries (the fastest way that's
    possible) that adds from one table to another table the records but if the
    current record already exist it must deny and goto next record.

    Thanks a lot in advance,

    Best regards,

    vb-er
     
  2. Loading...

    Similar Threads Forum Date
    India Cancel pvt firm's contract or will fast unto death, says ex-SGPC member Breaking News Feb 11, 2014
    Nature Big old trees grow faster, hold more carbon Breaking News Jan 27, 2014
    Is Fasting For Social Or Political Purposes Allowed in Sikhi? Sikh Sikhi Sikhism Dec 5, 2013
    Do sikhs need to keep fasts? Sikh Sikhi Sikhism Oct 13, 2013
    Fasting: Penance, Blessing, Hypocrisy or Me-ism? Sikh Sikhi Sikhism Jul 24, 2013

  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    See the thread 'Append query question!' elsewhere in this newsgroup for an
    example.

    --
    Brendan Reynolds
    Access MVP

    "VisualBasic@versatel.nl" <visualbasic@versatel.nl> wrote in message
    news:e6bmfe$4ho$1@news1.zwoll1.ov.home.nl...
    > Hello,
    >
    > Does anyone know how to create one or more queries (the fastest way that's
    > possible) that adds from one table to another table the records but if the
    > current record already exist it must deny and goto next record.
    >
    > Thanks a lot in advance,
    >
    > Best regards,
    >
    > vb-er
    >
     
  4. VisualBasic@versatel.nl

    VisualBasic@versatel.nl
    Expand Collapse
    Guest

    Hi,

    I cannot find that message, I guess I cannot download it any longer since
    it's long time ago.

    I have searched in this group at 'Append query question' but couldn't find
    anything.

    vb-er



    "Brendan Reynolds" <brenreyn@discussions.microsoft.com> schreef in bericht
    news:el$Dx57iGHA.2188@TK2MSFTNGP04.phx.gbl...
    > See the thread 'Append query question!' elsewhere in this newsgroup for an
    > example.
    >
    > --
    > Brendan Reynolds
    > Access MVP
    >
    > "VisualBasic@versatel.nl" <visualbasic@versatel.nl> wrote in message
    > news:e6bmfe$4ho$1@news1.zwoll1.ov.home.nl...
    >> Hello,
    >>
    >> Does anyone know how to create one or more queries (the fastest way
    >> that's possible) that adds from one table to another table the records
    >> but if the current record already exist it must deny and goto next
    >> record.
    >>
    >> Thanks a lot in advance,
    >>
    >> Best regards,
    >>
    >> vb-er
    >>

    >
    >
     
  5. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    Here it is ...

    http://groups.google.ie/group/microsoft.public.access/msg/324b1f8b57461455

    --
    Brendan Reynolds
    Access MVP

    "VisualBasic@versatel.nl" <visualbasic@versatel.nl> wrote in message
    news:e6c3f7$1jt$1@news6.zwoll1.ov.home.nl...
    > Hi,
    >
    > I cannot find that message, I guess I cannot download it any longer since
    > it's long time ago.
    >
    > I have searched in this group at 'Append query question' but couldn't find
    > anything.
    >
    > vb-er
    >
    >
    >
    > "Brendan Reynolds" <brenreyn@discussions.microsoft.com> schreef in bericht
    > news:el$Dx57iGHA.2188@TK2MSFTNGP04.phx.gbl...
    >> See the thread 'Append query question!' elsewhere in this newsgroup for
    >> an example.
    >>
    >> --
    >> Brendan Reynolds
    >> Access MVP
    >>
    >> "VisualBasic@versatel.nl" <visualbasic@versatel.nl> wrote in message
    >> news:e6bmfe$4ho$1@news1.zwoll1.ov.home.nl...
    >>> Hello,
    >>>
    >>> Does anyone know how to create one or more queries (the fastest way
    >>> that's possible) that adds from one table to another table the records
    >>> but if the current record already exist it must deny and goto next
    >>> record.
    >>>
    >>> Thanks a lot in advance,
    >>>
    >>> Best regards,
    >>>
    >>> vb-er
    >>>

    >>
    >>

    >
    >
     

Share This Page