Counting different objects in the same field

[chubby]

Using the =Count([last name]) I know it will count all the last names in that field in a report, can I count just the total number of smiths? If so how???

 

[JerryDennison]

Set a grouping level based on the last name. You can then use the header or footer along with the count function to give you your totals by name.

 

[dbourdea]

Jerry,

Can you give an example of the "grouping" statement?

 

[JerryDennison]

It isn't a statement. It is a property of the report. There is an icon on the toolbar for grouping/sorting. Press this button and you'll get the grouping/sorting dialog box. You can set your group level here along with whether or not you want and header or footer for it. "Advice is a dangerous gift, even from the wise to the wise, for all course may run ill." J.R.R. Tolkien