Print Page | Close Window

SigFigs.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
Printed Date: 21 Sep 2020 at 12:00am
Software Version: Web Wiz Forums 12.03 -

Topic: SigFigs.mdb (beginner)
Posted By: Roger Carlson
Subject: SigFigs.mdb (beginner)
Date Posted: 22 Jul 2008 at 10:39pm
Please consider donating $1 per sample downloaded, - find out why here .


This example illustrates how to round a number to a specified number of significant figures.

Significant figures requires two functions:

1) A function to find where the sigfig should be. "sig_fig_convert()" returns the offset from the decimal point where the number should be rounded. Parameters include the number needing rounding and the number of sig figs.

2) A function to round to that point. "round()" does the rounding to the specified sigfigs. Its parameters are the number needing rounding and the results of the sig_fig_convert() function.

Access 97 (18 KB): - uploads/5/
Access 2000 (31 KB): - uploads/5/

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -