Month End Grand Total and Page Number starting from 1 at the beginning of the Month
Hi! Hope someone could help me, it would be greatly appreciated.
1. On FM 9 I want to calculate my Month End weights of all the parcels that I delivered (I got it to work to calculate the daily weights, using a sub sum function) but
currently the summary Function calculates the running total of all the months which is not what I want. It must be Month by Month.
What formula must I use?
2. On the preview mode for printouts my page numbers, which is in the Footer, ends for the month on a number ie 12 or 13 for all the work that was done for a month.
Starting on a new Month it carries on to the next page no. but I would like it to start back at page 1 for the new Month and not continiuosly.
What must be done to rectify this?