Counting Unique Occurances
Posted by DeryckB on November 14, 2001 6:29 AM
I have a database of approx. 1000 records and need to count the number of times a reference against each record occurs using criteria in an adjacent column.
For example. Col.Code1 contains a reference 500012. Col.Code2 contains multiple references, many of which are duplicated, for e.g. 500500, 500501 etc. but are on the same row as reference to 500012.
There may be 15 entries for 500500, 12 for 500501. What I need to ascertain is that there is a count of 2 against 500012 and not 27.
Returning the count of unique references against the criteria specified is taxing my overwhelmed brain!