cvaden
Feb 6th, 2000, 08:04 AM
I'm using DAO (code).
Example:
I have 8 titles that may or may not be unique.
There are 2 titles per location.
Each location is duped for every title it holds.
therefore results look like this:
loc1 ttl1
loc1 ttl2
loc2 ttl1
loc2 ttl2
loc3 ttl1
loc3 ttl2
and so on...
I want it to look like this...
loc1 ttl1
ttl2
loc2 ttl1
ttl2
and so on...
Unfortunately there is NOT a set number of titles to locations.
How can I eliminate the duplicates?
It's like I have to inventory every location and then compare each on with every other one!
Any help would be greatly appreciated!
<c>
Example:
I have 8 titles that may or may not be unique.
There are 2 titles per location.
Each location is duped for every title it holds.
therefore results look like this:
loc1 ttl1
loc1 ttl2
loc2 ttl1
loc2 ttl2
loc3 ttl1
loc3 ttl2
and so on...
I want it to look like this...
loc1 ttl1
ttl2
loc2 ttl1
ttl2
and so on...
Unfortunately there is NOT a set number of titles to locations.
How can I eliminate the duplicates?
It's like I have to inventory every location and then compare each on with every other one!
Any help would be greatly appreciated!
<c>