Trying to Count Unique Records

[bert32hid]

I am appreciative of any help that can be offered!

The situation: One Table.... and the two important fields are very
repetative. So wanting to count how unique they are I placed each of those
fields alone in a seperate Query.

ie. Query 1: Group By(Topic)
Query 2: Group By(Sub1)

I can only seem to get it that it counts all of the records.... But I want
it to count the total number of UNIQUE Records. :-/

...
....

This is the next step after that... How to get it that in a query I can get
it that it does a count on the records that come out in a Query, eg. giving
another field in the query.

I think I have made this long enough, so Thanks again!!

 

[Jerry Whittle]

SELECT Count(*) AS CountOfDistinct
FROM (SELECT DISTINCT Topic, Sub1
FROM [One Table]);