Queries Access 97 (1 Viewer)

[chaulard]

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!!!!!!!!!!!!

 

[pcs]

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

 

[Pat Hartman]

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.