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