creating billing Statement Access 97

[healermoon]

At the bottom of my billing statement I want to show what is the amount due that is current, 30 days past due, 60 days past due, and 90 days past due. I was thinking the formula would be:

Sum[AmtDue]-Sum[AmtPaid]<[End Date]

or

Sum[AmtDue]-Sum[AmtPaid] AND <[End Date]

for the current due, AmtDue and AmtPaid are totaled up at the end of the statement, and [End Date] is a parameter ended when creating the statement. However that is not working so I am not sure if I am on the right path or not.

Thanks much for your help.

Kenny Renaud
IT Manager
Corral West Ranchwear Inc.

 

[dhookom]

What fields/values would you look at to determine the number of days past due? Would field/expression would you sum to calculate the Amount Past Due?

Can you provide some sample records and desired display?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[healermoon]

All of the invoices are total up in one column:

=Sum([fldAmtDue])

All of the Payments are totaled up in the next column:

=Sum([fldBillPayAmt])

And the total amount due:

=Sum([fldAmtDue])-Sum([fldBillPayAmt])

This works out just fine.

However I was told by the Controller that he wants to see at the bottom of the report what is currently due, what is 30 days past due, 60 days past due, and 90 days past due.

I am not sure how to calculate that.

Thanks



Kenny Renaud
IT Manager
Corral West Ranchwear Inc.

 

[dhookom]

You best ask your controller how he wants to calculate that. Give him some sample records and ask him what he would expect to see. That's his/her job, not yours or ours.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]