Hi!
I've searched through the threads and can't find anything similar to my problem. Hope I'm not repeating
Am running a query based on Accounts Receivable table.
I want a field that will show late fees based on 30 days, 60 days and 90 days past due.
The fields I am working with are [InvoiceAmount] and [30-60-90] and [LateFee].
I want the LateFee field to show results for the calculations:
30-59 days = InvoiceAmount * .10
60-89 days = InvoiceAmount * .15
90 > = InvoiceAmount * .20
Current = Null
I hope this is enough information
Thanks!!
I've searched through the threads and can't find anything similar to my problem. Hope I'm not repeating

Am running a query based on Accounts Receivable table.
I want a field that will show late fees based on 30 days, 60 days and 90 days past due.
The fields I am working with are [InvoiceAmount] and [30-60-90] and [LateFee].
I want the LateFee field to show results for the calculations:
30-59 days = InvoiceAmount * .10
60-89 days = InvoiceAmount * .15
90 > = InvoiceAmount * .20
Current = Null
I hope this is enough information
Thanks!!