Rounding Value Up to Whole Number

[PowellGirlTN]

I have a report footer that I'm adding values from the detail section. Many
of my values that I'm adding are .333. Once I sum the value in the footer, I
end up with not a whole number, for example 9.999. Is there a property I can
set to bring the value to the next whole number. Thanks for your help

 

[Evi]

Try
=- Int( - [MyField])

(note there is a - before the Int and before the my field)

Substitute the name of your own text box)

Evi


int(number*100 + 0.5) / 100

 

[PowellGirlTN]

Where do I put this, in the format control? I tried it there and it didn't
change the number to a whole number. I appreciate your help, thank you

Try
=- Int( - [MyField])

(note there is a - before the Int and before the my field)

Substitute the name of your own text box)

Evi


int(number*100 + 0.5) / 100

I have a report footer that I'm adding values from the detail section. Many
of my values that I'm adding are .333. Once I sum the value in the footer, I
end up with not a whole number, for example 9.999. Is there a property I can
set to bring the value to the next whole number. Thanks for your help

 

[Evi]

Combine it with your Sum field so that the text box with which you added up
your field now says

eg

= -Int(-Sum([YourField]))

Replace 'Your field' with the name of the field which you are summing.

Evi

Where do I put this, in the format control? I tried it there and it didn't
change the number to a whole number. I appreciate your help, thank you

Try
=- Int( - [MyField])

(note there is a - before the Int and before the my field)

Substitute the name of your own text box)

Evi


int(number*100 + 0.5) / 100

I have a report footer that I'm adding values from the detail section. Many
of my values that I'm adding are .333. Once I sum the value in the footer, I
end up with not a whole number, for example 9.999. Is there a

property I
can

set to bring the value to the next whole number. Thanks for your help

 

[PowellGirlTN]

Worked like a charm, thanks so much

Combine it with your Sum field so that the text box with which you added up
your field now says

eg

= -Int(-Sum([YourField]))

Replace 'Your field' with the name of the field which you are summing.

Evi

Where do I put this, in the format control? I tried it there and it didn't
change the number to a whole number. I appreciate your help, thank you

Try
=- Int( - [MyField])

(note there is a - before the Int and before the my field)

Substitute the name of your own text box)

Evi


int(number*100 + 0.5) / 100
I have a report footer that I'm adding values from the detail section.
Many
of my values that I'm adding are .333. Once I sum the value in the
footer, I
end up with not a whole number, for example 9.999. Is there a property I
can
set to bring the value to the next whole number. Thanks for your help