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