IIF query

[ShostyFan]

I have an inventory count query that returns a productCode, the date it was counted, and the total count.


I have a second query that gives me a productCode, date of sale, and qty sold.

I need a query that returns the sum of QtySold if the date is greater then the date counted.
Here is what I have:
QtySoldSinceCount: Sum(IIf([ReceiptDate]>[MaxDateCount],[sumofQuantity],0))

I get an error message that I am trying to run a query that does not include "productCode" as part of the aggregate expression.

I don't understand the error message, nor do I see another way to handle this problem.

[June7]

Post the entire attempted SQL statement. Or provide db for analysis.