[AccessD] Printing Decimals in a Report

Gary/Joe,
Thanks for the response, working fine now.

Ed Tesiny
EdTesiny at oasas.state.ny.us
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Thursday, June 28, 2007 12:53 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Printing Decimals in a Report
> 
> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>