Query - add totals

[ZOR]

Can someone please advise how I can get a further column in this query, showing an accumalative total. Many thanks


SELECT Orders.UnitPrice, Orders.Qty, CCur(Orders.UnitPrice*[Qty]/100)*100 AS Subtotals INTO new
FROM Orders;

 

[dhookom]

Do you have some sample records and desired results? If you want to create a running total, you need a field that describes the order of the records.

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]

 

[ZOR]

Many thanks. With the help of Remou I managed to get there, and yes thank goodness by luck, the records come out in ID order. Thanks, Regards.