Rounding in Access 97? (1 Viewer)

[Tracy]

There is no Round function in Access 97 (thank god there is in Access 2000). WIthout having to write a function does anyone know how I can sum what is DISPLAYED in a text box on a report?

At the moment I sum a textbox in the report footer, but rather than summing what the textbox DISPLAYS, it sums what the text box STORES (which is a three decimal place number).

Any ideas?

 

[Mile-O]

In the query that populates your report - if you want to get the integer value of the values and exclude all the decimal places you can use a calculated field and sum on that.


The calculation would basically add 0.5 to your value and use the integer function up on it.

So:

NewField: Int([YourField]+0.5)

Therefore, having the first values into it would return the latter values, which are ready to be summed.


3.282 returns 3
3.499 returns 3
3.5 returns 4
3.643 returns 4