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