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.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=268
Printed Date: 20 Nov 2019 at 3:28pm


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, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

SigFigs.mdb

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.

Download
Access 97 (18 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/Sigfigs97.zip - uploads/5/Sigfigs97.zip
Access 2000 (31 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/Sigfigs2k.zip - uploads/5/Sigfigs2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window