Date Range Report

[Bob V]

I have a Report that in controlled by a date range to open, it list invoices
.. If I select a date range of 1-May-2007 to 1-July- 2007, it will list all
Invoices and payments made in that range, if there is any total owing or
credit it will show in a text box above. My sub report
[Report.rptSubOwnerInvoiceAmount] shows the data between 1-May-2007 till 1
July 2007, it contains 2 Text boxes that I want to get information from

tbInvoiceDate

tbInvoiceAmount

I want to create a 3 text boxes

1- tbInvoiceDate >30 Days show Amount

2-tbInvoiceDate>60 Days show Amount

3-tbInvoiceDate>90 days show Amount



In this Report there is also Credit Payments but they are flagged [Flag]
Payments -1 and Invoices 0

Also Payments have no [InvoiceID] Number compared to Invoices

Thanks if you can point me in the right direction.....Bob