I need a bit of help with grouping on the detail portion of my report. I have created a column in my report called Weld Count that is keeping a running count of the items I need to count. The problem I am having is I need the Lot column next to the count to assign a number upon counts of 20. For Example: On Weld count 1-20 I need to add a 1 in lot column and on the next count of 20 I need to add a 2 and so on. I am attaching a copy of the report showing how it is setup and how I would like for it to look.
Thanks,
Patsy
