Grouping and Counting

[gdavid]

Hi,

I have read through the FAQs and haven't found anything that pertains to this problem.

I need to finish my report by figuring this out

Group 1 - Machine Type
Group 2 - Part Description
1 Item Description $
2 Item Description $
Group 2 - Part Description
3 Item Description
so forth and so on.

The count number needs to start at 1 by machine type and reset at next machine.

The running sum feature of by group or by all doesn't help.

Hope this info helps.

Thanks in advance

David

 

[JBinQLD]

sure the running sum should work fine for you? I think you've possibly got it in the wrong place. Create a control in the machine group header and and set it's value to 1. Set running sum to true, later you can set it to invisible but for now leave it showing.

In the machine group footer add a control with the control source ="Total is : " & me!YourControlNameAbove

JB