>>>Sorry, Trey, I lied. Adding the payroll field gives me "SQL: GROUP BY clause is missing or invalid." My bad.
>>
>>Hi Jim,
>>
>>It looks like facilitydata.facrebate and facilitydata.discountrate are not aggregated too.
>>
>>Thanks,
>>Aleksey.
>
>Aleksey,
>
>Trying to add those fields results in "Cannot GROUP by aggregate field." error. Thanks for trying, though.

Hi Jim,

I don't know how did you try, but it sure works for me.

CLOSE DATABASES all

CREATE CURSOR facilitydata ;
(facilityid I,;
 facilityname c(10),;
 facrebate I,;
 discountrate I,;
 payroll L)

CREATE CURSOR invoices ;
(custnumid I,;
invdate date,;
cashpaid Y,;
payroll Y,;
ccard Y,;
pcheck Y,;
salestax Y,;
shipcost Y)

CREATE CURSOR customers ;
(custnumid I, ;
facilityid I)


SELECT facilitydata.facilityname AS facility_name, invoices.invdate AS show_date,  ;
  SUM(invoices.cashpaid+invoices.payroll+invoices.ccard+invoices.pcheck-invoices.salestax-invoices.shipcost) AS TOTAL,  ;
  ROUND(SUM(invoices.cashpaid+invoices.payroll+invoices.ccard+invoices.pcheck-invoices.salestax-invoices.shipcost)*facilitydata.facrebate*0.01,2) AS facility_rebate,  ;
  ROUND(SUM(invoices.cashpaid+invoices.payroll+invoices.ccard+invoices.pcheck-invoices.salestax-invoices.shipcost)*facilitydata.discountrate*0.01,2) AS employee_disc,  ;
  IIF(facilitydata.payroll,"Yes","No ") AS payroll ;
  FROM  facilitydata ;
  inner JOIN customers    ;
  inner JOIN invoices    ;
  ON  customers.custnumid = invoices.custnumid    ;
  ON  facilitydata.facilityid = customers.facilityid;
  GROUP BY 1,2,facilitydata.payroll,facilitydata.facrebate, facilitydata.discountrate;
  ORDER BY facilitydata.facilityname, invoices.invdate

Thanks,
Aleksey.