Rounding down in a report field

[drnld]

Hi,



I am creating a student database for our instructors to track attendance and grades. The grades will be printed out as a progress report / student transcript. In order to comply with our accrediting agencies, I must calculate the units of study credits (two separate columns) and have the total Credits round down to the .5

So for example: column 1 = .40 , column 2 = .30, Total = .70 but the rounded down total would be .50

This is the Excel formula used to get that calculation =FLOOR((E11+G11),0.5) How do I create the expression to do the same in my report in that field?

Any help is appreciated.

Dottie

[hapm]

Didn't test it, but should work: Int([Total]*2)/2

[June7]

I tested the Excel and hapm expression. Both return 1.

If the total grades were 1.7, should round to 1.5? If so, try:

Int([Total]) + IIf([Total]-Int([Total])>=.5,.5,0)

[hapm]

So I simply missed to use 2.0 to make it a double division? Only a guess.

[June7]

Wow, yes, 2.0 made a difference.

I actually have opposite situation, which is to always round up and that's where I got my suggestion from, with a slight adjustment for the round down.