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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rounded up to the next $1000.

Status
Not open for further replies.

sco2222t

IS-IT--Management
Nov 7, 2006
5
CA
I am using report smith on sql , this is the result that I want

rounded up to the next $1000.

Example
88,200 = the report should print this 89,000.

44,000.21 = should print this 45000
44.000.00 = should print this 44000
45,200.00 = should print this 46000
44,700.00 = should print this 45000
round(m,n) does not work , only work for some
Thank you for taking the time to respond to my fist question

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top