how do I produce numbers to 2 significant figures

G

Guest

I have a data base with numbers in to 1 decimal place. I wish to report these
numbers to 2 significant figures.
i.e. if the number is 10 or above then whole numbers should be shown. If the
number is below 10 then 1 decimal point should be shown. 22.6 = 23 9.7
= 9.7
My numbers ar never minus or larger than 100.0.

Please help me.

Thanks
Tommy
 
G

Guest

In the control source of the control you want to show the data put:
=iif([MyNumber] < 10 ,round([MyNumber],1),round([MyNumber],0)
 
G

Guest

Thanks schasteen but unfortunately I already have a control source in the
control. This control source is linked to a query and table.
 
G

Guest

Replace the control source to this. Just make sure the control is not named
the same as the column from the query. So in the example I gave you, make
sure the control is not named MyNumber or you will get a circular referance,
or you can add a new control to your form or report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i show 3 significant figures 1
Significant figures as a conditional format 3
Significant figures 7
How can I round a number to 2 significant figures 2
Round Function (Significant Figures) for Large Numbers 3
How to calculate/properly display significant figures ending in 0 5
Fill/Extend Series adding decimal points to some numbers 1
Stop excel changing the value of numbers in european formt 7

Top