"NickHK" wrote in message
...
Vass,
Can you not edit the SQL that pulls the data from the DB to include a
calculated field of Qty*Sales AS TotalSales ?
Or am I missing the point ?


I could if I knew how
the SQL already removes duplicates and some rows that are blank
with this:
Select * From itran INNER JOIN ihead ON itran.it_doc = ihead.ih_doc WHERE
itran.it_status = 'A' AND ihead.ih_quotat = "" AND itran.it_stock <""

Can you offer an addition to it?
thanks
--
Vass