[AccessD] A2003:Percentages

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



More information about the AccessD mailing list