View Full Version : number formatting


dhoffman
08-11-2000, 09:17 AM
I need to take a number from a table and output it on a report according to a certain number of significant digits. For example, given three sig digs, 1.875 needs to output as 1.88 and 13.57 needs to output as 13.6. As you can see I can not simply set the number of decimal places. Sometimes I may not have any decimal places. 235.72 should output as 236. How do I format a number by significant digits in Access?