How do you set up a 12 month running total?

[Rangoon]

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,

HJ

[RussBaker]

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?