Hi everybody,

I have built a Statement Query which contains ,among other things,a column showing customer number, another column showing invoice numbers and a column showing amount outstanding.

I am not successful in finding the criteria to establish a sum by customer number. I need to have a logical formula entered that would enable the query to automatically understand that at each change of customer number in the Customer ID column, a sum has to be done in the following line of the last invoice in the amount outstanding column.

Can somebody help???

Thanks!!!!!!!!!!!!

are you going to use the query as the record source for a report?

if so, you can use sorting/grouping in the report to generate totals by customer.

hth,
al

A query cannot produce a recordset that contains BOTH detail and summary records. If you want to see both, you need to do it with a report.