[AccessD] Minimum number of decimal places

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