I am new to MS Access and have a few tables all with Company Name and Date (other fields are completely different). I would like to create a query to append a new record to all tables only if that record (the two fields--Company Name and Date) don't already exist. The company name can be duplicated but not the company name and date. So if it has the same company name and a new date then I'd want it to add the record but if they both already exist together then I do not..... any help would be greatly appreciated.
1 Replies - 425 Views - Last Post: 30 June 2014 - 05:19 AM
Replies To: Append record only if record doesn't already exist
Re: Append record only if record doesn't already exist
Posted 30 June 2014 - 05:19 AM
They right way to do this would be to create a multiple-field (no duplicates) index on the Company Name and Date, so if you try to insert a field with the same Company Name and Date, the insert will fail.
Page 1 of 1