Hello,
I am trying to Group some records by order number. Each order has a count, and I want to sum up the count column only if a certain value does not exist in another column. Here's my stab at it, but this query still adds rows that I don't want.
SELECT Data.ShopOrder, Sum(IIf(DCOUNT("[Set]","Data","[Set] = 30"),Count,0)) AS Expr1
FROM Data
GROUP BY Data.ShopOrder;
Test.accdb
Thoughts?