Update Queries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Les (anonymous_at_discussions.microsoft.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 04:47:53 -0800

Did you try setting the unique values property to yes in
the append query?

>-----Original Message-----
>Hi
>
>Sorry, this was an earlier posting, hope that someone
might be able to help
>
>I am using an append query to append data into a blank
table (source of data
>is linked from a Lotus Notes db)
>
>I then need to run an update query on the data which has
been appended to my
>table.
>
>HOWEVER, first I need to remove the duplicates from my my
newly appended
>(but not yet updated) table
>
>How would I do this please?
>
>Cheers
>
>Jake
>
>
>.
>

Relevant Pages

  • Update Queries
    ... Sorry, this was an earlier posting, hope that someone might be able to help ... I am using an append query to append data into a blank table (source of data ... first I need to remove the duplicates from my my newly appended ... Jake ...
    (microsoft.public.access.queries)
  • Re: Append Query
    ... I have not written any SQL. ... to doing an append query: make a select query, change it to an append query, ... There are no duplicates in the individual tables. ... is there another solution besides puttng these tables into Oracle? ...
    (microsoft.public.access.queries)
  • RE: Append Key Violation
    ... columns to see if any contain the properties INDEXED DUPLICATES NOT ALLOWED. ... Temp table is [ImportHR] with no PK ... IME Sentence Mode= None ... The append query has this SQL: ...
    (microsoft.public.access.queries)
  • Re: HELP - Random numbering & Random ASCII
    ... I have a table that I've created and I'm trying to do an append query ... characters for this "ItemNo" field so I don't have to manually enter ... but requirement that there be no duplicates means that you don't ... Don't bother checking for duplicates as the keys are generated, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Importing changing data from Excel
    ... > Mortgage fee ... > The permanent table id called 'lead details' and currently has exactly the ... > And this is the SQL view of the append query ... > I've just looked at the update query in datasheet view and noticed that it ...
    (microsoft.public.access.externaldata)