Help with form

  • Thread starter Thread starter Ling
  • Start date Start date
L

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

===============================
 
Back
Top