[AccessD] A2003:Percentages

Reuben Cummings reuben at gfconsultants.com
Thu Mar 2 08:09:55 CST 2006


I don't totally understand your problem, but I beleive if you use the
"Percentage" format on a text box and the data is .2, for example, the
report will show 20%.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren HALL
> Sent: Wednesday, March 01, 2006 6:52 PM
> To: AccessD
> Subject: [AccessD] A2003:Percentages
>
>
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>







More information about the AccessD mailing list