Exclude duplicates append query

[rayted]

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

[isladogs]

You set a filter for where the primary key field value in the destination table is null

[rayted]

Not sure I follow ridders52

Can you see my image and advise?

Thank you

[isladogs]

Combining with your other post (which wasn't really necessary)

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

[rayted]

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

[isladogs]

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