Results 1 to 6 of 6
  1. #1
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34

    Exclude duplicates append query

    Hi guys,



    Getting my head round an append query. is there a way in which I can instruct access NOT TO input duplicate data (exactly the same content from previous rows)?

    Thank you

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You set a filter for where the primary key field value in the destination table is null
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34
    Not sure I follow ridders52

    Can you see my image and advise?

    Thank you
    Attached Thumbnails Attached Thumbnails accesspic.png  

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Combining with your other post (which wasn't really necessary)

    Code:
    INSERT INTO [In Progress - Responding tbl] ( Received )
    SELECT [In Progress-Responding].Received
    FROM [In Progress-Responding]
    WHERE [In Progress - Responding tbl].Received Is Null;
    BUT why are you duplicating data in more than one table?

    ALSO you NEED to sort out your naming convention
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34
    I think this works. I`m retrieving emails from a specific folder in outlook - then from the table, I`m trying to count the emails

    Thank you ridders52

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I know it will work but I still see no reason to append the data to a new table just so you can count it!
    You could just count the records in the original table
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Append Query to a table (Without Duplicates)
    By cmorten in forum Queries
    Replies: 12
    Last Post: 11-28-2016, 02:44 PM
  2. Replies: 3
    Last Post: 09-11-2015, 03:22 PM
  3. Append query without duplicates using two id's
    By sdel_nevo in forum Queries
    Replies: 2
    Last Post: 02-20-2015, 08:25 AM
  4. Append query is creating duplicates
    By D4WNO in forum Database Design
    Replies: 3
    Last Post: 12-10-2012, 10:47 AM
  5. Append query creating duplicates
    By dhicks19 in forum Queries
    Replies: 1
    Last Post: 05-14-2012, 06:36 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums