[AccessD] Minimum number of decimal places

Stephen stephen at bondsoftware.co.nz
Sun Jun 22 00:10:00 CDT 2008


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




More information about the AccessD mailing list