How do you set up a 12 month running total?

June 27, 200223 yr

I want to be able to show a running 12 month sales total. Where at the end of each month the new month is added and the oldest month is dropped off.

Thanks for your help,

June 27, 200223 yr

Not too sure if this is really what you're after, but my PowerBook battery is running flat and I left the charger at work... But it might be a start.

So, on any date in June 2002, for example, you would want to show sales from 1 June 2001 to 31 May 2002 inclusive? If you script a find like this, it should bring up the previous 12 months records, excluding any in the current month.

Enter Find Mode[]

Insert Calculated Result[Payment_Date,DateToText(Date(Month(Status(CurrentDate)),1,Year(Status(CurrentDate))-1)) & "..." & DateToText(Date(Month(Status(CurrentDate)),1,Year(Status(CurrentDate)))-1)]

Perform Find []

You could then have a sub-summary report on the found records by month, not showing the body part, with running total summary fields in the sub-summary parts.

Is that what you're trying to achieve?