I cannot make the variable portion work...

Thoughts?

SELECT ffinvoice.invdate AS "Inv. Date", ffitem.invnum AS "Inv. No.", ffitem.cusnum AS "Cust. No.", ffinvoice.cusname AS "Company", ffinvoice.repnum AS "By", Sum(ffitem.price*ffitem.qty) AS "Sales", Sum(ffitem.cost*ffitem.qty) AS "Cost", Sum(ffitem.price*ffitem.qty-ffitem.cost*ffitem.qty) AS "Profit"  FROM ffinvoice ffinvoice, ffitem ffitem  WHERE ffitem.cusnum = ffinvoice.cusnum AND ffitem.invnum = ffinvoice.invnum AND ((ffinvoice.invdate Between [Start Date] And [End Date]))  GROUP BY ffinvoice.invdate, ffitem.invnum, ffitem.cusnum, ffinvoice.cusname, ffinvoice.repnum  ORDER BY ffinvoice.invdate, ffitem.invnum, ffitem.cusnum, ffinvoice.cusname, ffinvoice.repnum