[AccessD] Printing Decimals in a Report

Gary Kjos garykjos at gmail.com
Wed Jun 27 23:52:50 CDT 2007


Often times the calculated fields won't let you format using the
format property on the query. In those cases you need to wrap the
calculation in a
format({Your Calculation here},".00")

GK

On 6/27/07, Tesiny, Ed <EdTesiny at oasas.state.ny.us> wrote:
> I feel really stupid asking this, but a colleague is trying to print a report based on a query where there are some calculated fields.  The query shows the fields to like 12 decimal places to the right of the decimal, she would like just 2.  I have a brain cloud because I know I have done this but can't figure it out.  For example, a calculated field would be Admission_Rate: [Admissions]/[Contacted] ...Oh yeah, some of these calculated fields have an Iif function.  Please help!
> Ed
>
> PS  If this was posted before  I apoligize ut I didn't see it post.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list