group count

[Jeff Clark]

how do i get group count thanks

 

[Rick Brandt]

how do i get group count thanks

In what context? Do you want to do this in an Expression, a Query, a Report?

 

[Jeff Clark]

how a bout an expresson, and a query

In what context? Do you want to do this in an Expression, a Query, a Report?

 

[Rick Brandt]

how a bout an expresson, and a query

DCount("*","SomeTableOrQuery","GroupCriteria")

SELECT GroupingFieldName, Count(*) AS Cnt
FROM SomeTableOrQuery
GROUP BY GroupingFieldName

 

[Duane Hookom]

Assuming you have a group header and want to count the number of groups, add
a text box to the group header
Name: txtGroupCount
Control Source: =1
Running Sum: Over All

Add a text box to your report footer
Control Source: =txtGroupCount