I created a query that calculates a percent .0200 to a budgeted amount. Percent_Incr = (.0200 * [Budgeted_Amount] + [Budgeted_Amount])what happens in the query I get the correct value without the period and the cents added even thought it has a fixed format. Then when I creates the report it is rounded down with a fixed format on the report. I would like the report to displays 1,113.00 instead of 1,112.95. All cents on the dollar must be equal to zeros. In other words I needs the digits to the right of the decimal to equal zero and the digits to the left of the decimal to be rounded up.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rounding down a calculation for display on the report.
- Thread starter jaggar
- Start date
- Status
Similar threads
- Locked
- Question
