Different values in a record set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 30 Nov 2004 12:01 GMT

Is there an easy way to determine how many diiferent values appear in a query
or table. I am not interested in how many time a particular value appears
just in counting the number of different values that appear.

Thanks in advance

Matt

Reply to this Message

Nikos Yannacopoulos - 30 Nov 2004 14:13 GMT

Matt,

Assuming I want to count different customers (field: CustID) invoiced in
table tblInvoices, the SQL for the query would be:

SELECT Count(qry1.CustID) AS CountOfCustID

FROM (SELECT tblInvoices.CustID FROM tblInvoices GROUP BY
tblInvoices.CustID) AS qry1

Just use your table/query and field names instead.

HTH,

Nikos

> Is there an easy way to determine how many diiferent values appear in a query
> or table. I am not interested in how many time a particular value appears
[quoted text clipped - 3 lines]
>
> Matt

Reply to this Message