I have a table that contains a field called container_number and another field called received_date.
I am using an append query to get new data from an Excel spreadsheet to populate the access table.
These containers are recycled and will be returned and added to the database again.
The problem that I have is, I want the table to be able to store the container_number multiple times but only with a unique date. If I run the append query, it just adds the same container and date. If I ran it three times, the table will have three duplicate records. I only want to duplicate the container number as long as the date received is different.
Thanks in advance - John
I am using an append query to get new data from an Excel spreadsheet to populate the access table.
These containers are recycled and will be returned and added to the database again.
The problem that I have is, I want the table to be able to store the container_number multiple times but only with a unique date. If I run the append query, it just adds the same container and date. If I ran it three times, the table will have three duplicate records. I only want to duplicate the container number as long as the date received is different.
Thanks in advance - John
