Hello all,

I am doing my uni project, database system for bakery. Now I am trying to do a statement report for my customers. Basiclly, the report contain customer infor at report header and all unpaid invoice(s) at report detail section and summary balance at the bottom of the report. At this stage, my report contain customer information, unpaid invoice details (from Query), BUT I DON'T KNOW HOW TO FIND OUT SUMMARY BALANCE WHICH IS:
1. Total unpaid invoice at current week
2. Last week total unpaid invoice
3. Last 2 weeks total unpaid invoice
4. And total unpaid invoice over last 2 wks, if there are any balance overdue left.

ANY CAN HELP, PLEASE PLEASE PLEASE.

Many Thanks.

May

Have you tried to write this in a SQL format? Create a recordset, and then have your report based on that recordset?

John