J
Jeff Clark
how do i get group count thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
Jeff Clark said:how do i get group count thanks
In what context? Do you want to do this in an Expression, a Query, a Report?
J
Jeff Clark
how a bout an expresson, and a query
Rick Brandt said:In what context? Do you want to do this in an Expression, a Query, a Report?
R
Rick Brandt
Jeff Clark said:how a bout an expresson, and a query
DCount("*","SomeTableOrQuery","GroupCriteria")
SELECT GroupingFieldName, Count(*) AS Cnt
FROM SomeTableOrQuery
GROUP BY GroupingFieldName
D
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
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