[AccessD] Decimal point with no places to the right

? format(111&,"0.#")
111.

Too true. Works for integer types, though not sure if Rocky specified integers.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, February 04, 2009 1:46 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Decimal point with no places to the right

Hi Lambert

> Your format string shows one decimal place (as I would expect it to)

Yes, but none for an Integer - that I understood was the issue.

/gustav

>>> Lambert.Heenan at aig.com 04-02-2009 19:23 >>>
Gustav? Your format string shows one decimal place (as I would expect it to) ? format(111.12,"0.#")
111.1

This shows no decimal places...
? format(111.12,"0.")
111.

Lambert