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
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
Not sure I follow ridders52
Can you see my image and advise?
Thank you
Combining with your other post (which wasn't really necessary)
BUT why are you duplicating data in more than one table?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;
ALSO you NEED to sort out your naming convention
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
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