Counting an summing (does anyone use this on a sat)

[EscapeUK]

I have a report which looks a bit like this


Group1
Group2
Group 3
Details
this is line one 4
this is line two 2
this is line three 1
Group 3
Details
this is a nother line 1
this is another line 1


I would like total in the group 2 footer saying there are 2 group 3's and another total in group 2 footer showing that there are a total of 5 details.

If you can help please keep the instructions simple and provide step by step help.

That would be great

thanks

 

[Rohdem]

have you looked at using the DCOUNT function?
Mike Rohde
rohdem@marshallengines.com