Darren DICK
darrend at nimble.com.au
Mon Jun 26 00:11:20 CDT 2006
Brilliant Thanks Michael PS Say Hi to Anita Darren ------------------ T: 0424 696 433 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Maddison Sent: Monday, 26 June 2006 2:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003: Showing to 4 decimal places Isn't it something like format( [myCol],"0.0###") cheers Michael M Subject: [AccessD] A2003: Showing to 4 decimal places Hi All <sigh> brain fade here - what is the correct syntax to show a display up to 4 decimal places But some numbers will genuinely be 1, 2 or 3 decimal places and as such only need to show 1, 2 or 3 decimal places respectively Many thanks in advance Darren -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com