Help with form

[Ling]

I have a form that opens in datasheet view
This form has a field called Qty
Eg:
Qty Total (Shld be accumulating)
---- -------
20 20
30 50

I want the effect as above.How do I do this?Currently, the
total column shows 50 in both rows.
Thanx for any help

Ling

 

[StCyrM]

Hi Ling

This is simple enough..Here is the SQL from one of my apps. If you want I can
send you the actual Table & Query involved. Let me know.

Best regards

Maurice


SELECT Orders.EmployeeID AS EmpAlias, Sum(Orders.Freight) AS SumOfFreight,
Format(DSum("Freight","Orders","[EmployeeID]<=" & [EmpAlias] & ""),"$0,000.00")
AS RunTot
FROM Orders
GROUP BY Orders.EmployeeID;

===============================