Acc2007 can't get DSUM to work in a query

[DougP]

I got the example

http://support.microsoft.com/kb/290136

here is my full SQL
SELECT test.WareHouse AS WarehouseAlias, Sum(test.Qty) AS SumOfQty, DSum("WareHouse","Test","[Qty]<=" & [WarehouseAlias]) AS RunTot
FROM test
GROUP BY test.WareHouse;

I don't have the Northwind db for 2007
I have another PC with Acc2002 and tried the example on Northwind in 2002 and it works perfect.


DougP
< I love mine

http://www.robots2000.com

 

[PHV]

Perhaps this ?

SELECT WareHouse AS WarehouseAlias, Sum(Qty) AS SumOfQty, DSum("WareHouse","Test","[Qty]<=" & [WareHouse]) AS RunTot
FROM test
GROUP BY WareHouse, DSum("WareHouse","Test","[Qty]<=" & [WareHouse])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886