View Full Version : Reports - Summing values based on ranges


terry
01-30-2010, 05:58 AM
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
01-30-2010, 09:41 AM
Try

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