Dcount in Access 2010 query

[haqm1960]

I am using following query but Dcount is not working, I tried various way and help from net, not working. Your are the expert people, could you please check

SELECT


DCOUNT(opo.[PO Number]) AS [po],
Count(opo.[Item Number]) AS [Item Number],
Sum(opo.[Total value]) AS [SumOfTotal value],
Sum(opo.Quantity) AS SumOfQuantity,
Sum(opo.[Qty delivered]) AS [SumOfQty delivered], opo.Vendor,
opo.Name,
opo.[Delivery Status]


FROM opo




GROUP BY
opo.Vendor,
opo.Name,
opo.[Delivery Status];

[CJ_London]

'not working' is not very helpful - you should be getting an error message which will help to explain.

So far as I can see, you should be using count, not dcount.