By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,940 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,940 IT Pros & Developers. It's quick & easy.

Rounding Up problems

P: n/a
Hello Everyone

I'm using Access 2000.

I have a slight quirk in my database which I am sure is logical and
easy to rectify-

basically my database adds up six scores and works out an average,
i.e.

(3+3+3+4+4+4)/6 = 3.5 and displays correctly as 4 (to 1 signficant
digit)- not rocket science I know! However when my scores are:
(4+4+4+5+5+5)/6= 4.5- it displays as 4 when I want it to show 5!!

The final score is displayed in a text box.

Any help is much appreciated.

thanks

D.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,

You'll probably get a whole bunch of suggestions on this...
This KB article
http://support.microsoft.com/default...;en-us;Q155696 contains my
personal favorite.

It allows you to specify a direction (round up / round down) as well as the
increment (eg .05 rounds currency values to the nearest nickel.)

Don

"deejayquai" <de********@hotmail.com> wrote in message
news:3a*************************@posting.google.co m...
Hello Everyone

I'm using Access 2000.

I have a slight quirk in my database which I am sure is logical and
easy to rectify-

basically my database adds up six scores and works out an average,
i.e.

(3+3+3+4+4+4)/6 = 3.5 and displays correctly as 4 (to 1 signficant
digit)- not rocket science I know! However when my scores are:
(4+4+4+5+5+5)/6= 4.5- it displays as 4 when I want it to show 5!!

The final score is displayed in a text box.

Any help is much appreciated.

thanks

D.

Nov 13 '05 #2

P: n/a
"Don Leverton" <le****************@telusplanet.net> wrote in message news:<Upnzc.19082$lN.18316@edtnps84>...
Hi,

You'll probably get a whole bunch of suggestions on this...
This KB article
http://support.microsoft.com/default...;en-us;Q155696 contains my
personal favorite.

It allows you to specify a direction (round up / round down) as well as the
increment (eg .05 rounds currency values to the nearest nickel.)

Don

"deejayquai" <de********@hotmail.com> wrote in message
news:3a*************************@posting.google.co m...
Hello Everyone

I'm using Access 2000.

I have a slight quirk in my database which I am sure is logical and
easy to rectify-

basically my database adds up six scores and works out an average,
i.e.

(3+3+3+4+4+4)/6 = 3.5 and displays correctly as 4 (to 1 signficant
digit)- not rocket science I know! However when my scores are:
(4+4+4+5+5+5)/6= 4.5- it displays as 4 when I want it to show 5!!

The final score is displayed in a text box.

Any help is much appreciated.

thanks

D.


Thanks Don -

however I'm not sure if that solves things because I can't see how I
can predetermine whether I want to round up or down- I basically want
the system to know that whenever a value reaches 0.5 it automatically
rounds up to the next whole digit- which is what I was taught should
be done when calculating to 1 significant digit, and for some reason
it doesn't like doing it for 4.5!!

Hope you [or someone] are able to help.

D.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.