Counting Unique Values!

[vdanelia]

How to Find unique values in a Table Field from Unbound text box
=Dcount

[Field] (Table Name is DATA and the field name is Dealer)

Thanks

 

[llkhoutx]

Query table Data, with only field Dealer selected, and group (select the sigma symbol) in the que window.

If you merely wants to "count" the records, in the QBE window, change the word "Group By" to "Count", via the picklist.

 

[Brianwarnock]

The only way i know to count unique values is to Select them in one query and count them in another

Select Distinct thefield
from thetable


select Count(thefield) as .. OR count(*) as alias
From the query

Count(*) if you want to count Blanks.

Brian