Ralph Gould
asked on
Access Select query producing duplicate records
running access 2k10, query which is producing multiple duplicate records in the result. Not on all records, just some. I've checked all related tables and there are no duplicates. I've added "Distinct" to the query but no change.
I've attached an rtf doc with the access query and the sql view. Any help greatly appreciated.
Document.rtf
I've attached an rtf doc with the access query and the sql view. Any help greatly appreciated.
Document.rtf
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
if u look at the sql in the attachment above, I inserted distinct after SELECT in the vba sql statement.
For a few entries, not all, i will get 2 to 4 exact duplicate records for a given acronym.
For a few entries, not all, i will get 2 to 4 exact duplicate records for a given acronym.
jsgould, I am sorry to be a pain here, but that is simply not possible. There has to be some difference in the records.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I solved it by determining it to be a non-problem
ASKER