FoxStudent
Technical User
How would you round up the value returned by an aggregrate function.
Thank you,
Grainne
Thank you,
Grainne
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rounding
- Thread starter FoxStudent
- Start date
- Status
tlbroadbent
MIS
You can use the Round function - Round(expression [,numdecimalplaces]).
Example: Round(Sum(Value1),2) Terry
Example: Round(Sum(Value1),2) Terry
MichaelRed
Programmer
But, If you really mean rounf UP, rember to add 0.5
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question