I received this error message when I tried to open a query:
“You tried to execute a query that does not include the specified expression ‘Customer’
as part of an aggregate function.”
I believe it’s referring to the Sum function in my SQL statement below. But why? And how can I fix it?
SELECT OTShipping.Customer, OTShipping.CustomerNumber, OTShipping.PartNumber, OTShipping.ProductType, Count(OTShipping.ID) AS NumShipments, Sum(-[OTShipping.qlate]) AS NumLate
WHERE (((OTShipping.ActShipDate)>=#5/1/2002# And (OTShipping.ActShipDate)<=#5/31/2002#));