skwilliams
Registered User.
- Local time
- Today, 06:19
- Joined
- Jan 18, 2002
- Messages
- 516
I have a linked table that is appended daily to the database.
This table has fields such as [dtDate], [FName], [LName], [Address], [Sample1], [Sample2], [Sample3], etc up to [Sample10]. Yes, I know, not my idea.
I need to remove duplicate samples. The thing is sample1 and sample4 could contain the same sample and one needs to be removed. Is there a way I could do that with a query or do I need to append the data to another table with the proper structure (FName, LName, etc in one table joined to another table with the sample items.) If so, how can these be appended knowing the original data is structured as shown above?
This table has fields such as [dtDate], [FName], [LName], [Address], [Sample1], [Sample2], [Sample3], etc up to [Sample10]. Yes, I know, not my idea.
I need to remove duplicate samples. The thing is sample1 and sample4 could contain the same sample and one needs to be removed. Is there a way I could do that with a query or do I need to append the data to another table with the proper structure (FName, LName, etc in one table joined to another table with the sample items.) If so, how can these be appended knowing the original data is structured as shown above?
