Removing duplicate items from after a query....

[cvaden]

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>

[danix]

Look at SQL statements using SELECT DISTINCT
hope this helps

------------------