Reports - Summing values based on ranges

[terry]

I have a report which lists 'Invoice Dates' and also lists how old the Invoice is by 'number of days'.
I need to total the 'Invoice Values' based on the 'Number of Days' the invoice is overdue.
i.e. Total all invoices between 0 & 60 days old. The value to sit in Report Footer.

Simple programming problem for somebody!

Terry

 

[pbaldy]

Try

=Sum(IIf(NumberOfDaysField < 61, AmountField, 0))