I am writing a bookkeeping application and would like to display balances outstanding for invoices overdue by 30 60 90 day periods.

What I would like to acheive is have 3 fields 30 60 90 which dynamically calculate balances based on age of invoice and result is balance of those invoices.

Can anyone point me in the right direction

Brudders,

Check out the following example file. I think that it will answer your questions.

dateexample.zip

Reply to computer_geek

Many thanks for the example it really helped with the date calculation, could you tell me the balance for invoice only calculated for that individual record how can I get balance fields for 30/60/90 days to calculate the whole table of invoices and give the total of all records.

Thanks again

Brudders -- You do it with summary fields. You create a summary field and when you do, you specifywhich field to sum. It displays the sum for whatever found group you have selected.

I added attached a sample.

datepart2.zip

Thanks for all your help, with your examples I was able to tailor and get required result for my app. Your help is very much appreciated.