>>I think we have a winner! Now explain to me why those fields are NOT considered part of an aggregate function, if you would!
>>
>
>Hi Jim,
>
>
> ROUND(SUM(...)*facilitydata.facrebate*0.01,2) AS facility_rebate, ;
> ROUND(SUM(...)*facilitydata.discountrate*0.01,2) AS employee_disc, ;
> IIF(facilitydata.payroll,"Yes","No ") AS payroll
>
>
>ROUND and IIF are not aggregate functions, thus those three columns from facilitydata table are not aggregated.
>
>Thanks,
>Aleksey.
Thank you very much. The IIF() was known, but the ROUND() was not. My misunderstanding as how to handle the grouping in this case.