View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Vass[_6_] Vass[_6_] is offline
external usenet poster
 
Posts: 2
Default getting Excel to create an extra column


"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