Recent content by rtsmith555

I keep getting an error when I try to run this stating: "Your query does not include the expression 'Iif([DEMAND Last 36 Mos]<3,0,[MAX Qty 3-Mo]-[Balance])' as part of an aggregate function." I have included the expression under GROUP BY, however, so I'm at a loss. I have added the expression...

Returning to Access after well over a decade. Still trying to work out Access SQL formats and methods.