Darren HALL
darrend at nimble.com.au
Wed Mar 1 17:52:00 CST 2006
Hi All Cross posted to dba_SQL list Got a percentage format Q Is ist possible to do the calcs and display the end result as a percentage actually in the column rather than do the converts and formats on the form or report? EG select ac.Description, sum(s.TotalCost), '% - ????' from InvoiceChargeSummary s join AccountCostCentre ac on s.AccountNo = ac.AccountNo where s.InvoiceNo = @InvoiceNo returning: AUBURN 50.00 20% MELBOURNE 100.00 40% WA 100.00 40% Many thanks DD