[AccessD] Format to round to the thousand or million

That's neat Gustav. I can think of plenty of times that would have been a
quick alternative on reports. Thanks for the tip. (Now all I have to do is
remember it!)

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
Subject: [AccessD] Format to round to the thousand or million
Date: 20/04/06 10:10


Hi all

Did you know that Format() will let you perform a 4/5 rounding to the
thousands or millions etc.?
The trick is to append thousand separators to the format string:

curAmount = 3900725021.36

? Format(curAmount,"#,##0")
3,900,725,021

? Format(curAmount,"#,##0,")
3,900,725

? Format(curAmount,"#,##0,,")
3,901

? Format(curAmount,"#,##0,,,")
4

The same format strings can be applied as Format property of a Textbox.

/gustav

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2