I have a report that takes the name of a company, and a subreport lists all of the outstanding invoices for the company. It also calculates and displays how many days old each invoice is.
I would like the report to determine what invoices are current, one month old, two months old, and more than two months old, and then multiply each invoice amount by the appropriate finance charge to come up with a grand total.
Can anyone point me in the right direction with how to do this? I've tinkered with for loops, but I'm not sure what the syntax should be (or if that's even the best method). Any advice would be appreciated!
Thanks! -dcorey
I would like the report to determine what invoices are current, one month old, two months old, and more than two months old, and then multiply each invoice amount by the appropriate finance charge to come up with a grand total.
Can anyone point me in the right direction with how to do this? I've tinkered with for loops, but I'm not sure what the syntax should be (or if that's even the best method). Any advice would be appreciated!
Thanks! -dcorey
