Thanks again.

The last code needed a GROUP BY to work, but it works!

The first one didn't. It came back saying "Incorrect syntax near DISTINCT".

I assume that's the COUNT(DISTINCT...)?

Cheers