[AccessD] Minimum number of decimal places

Hi Stephen

I would rather use:

  Format(field, "#0.0#")

/gustav

>>> stephen at bondsoftware.co.nz 22-06-2008 10:07 >>>
Got it.   Format(field,"##0.0##) does perfectly.

Stephen Bond 


-----Original Message-----
From: Stephen 
Sent: Sunday, 22 June 2008 5:10 p.m.
To: 'Access Developers discussion and problem solving'
Subject: Minimum number of decimal places

The table has a currency field which (in my case) stores numbers with 0
or 1 or 2 decimal places.  I want to generate a query which shows a
minimum of 1 dp (so value 3 becomes 3.0) while leaving - for example -
the value 2.6 to show as 2.6 and the value 2.05 to show as 2.05.

There must be a simple Format string to do this - any help please.

Stephen Bond