Rounding Up problems

[deejayquai]

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.

[Don Leverton]

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.

[deejayquai]

"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.