how to stop rounding in reports (1 Viewer)

[tracyfarmer]

I have configured a report to pull information in from another software. When I create my totals in the footer, I want it to show only the whole numbers not the decimals. When I remove the decimals from the format field, the total is then rounded up to the next whole number. How can I stop it from doing this?

 

[Rich@ITTC]

Hi Tracy Farmer

I would suspect that your field is the data type Number (naturally) and that the Field Size (lower half of the screen in Design View for the table - first property) is set to Integer or Long Integer (so it will save whole numbers - integers).

Change the setting to Single or Double .. no trouble!

HTH


Rich Gorvin

[This message has been edited by Rich@ITTC (edited 03-21-2001).]

 

[tracyfarmer]

I guess I should have stated that the information for my report comes directly to reports through ODBC. There is no table for me to edit the formats in. Any other thoughts?

 

[norm]

well if the problem is that it is always rounding up, try doing the rounding in the text box. for example:

=Round([Field Name],0)

or specifics:
=Round(8.45,0) would equal 8
=Round(8.55,0) would equal 9