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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rounding off a number to the next highest integer 1

Status
Not open for further replies.
sikar

sikar

Programmer
Jun 4, 2003
15
US
In my report i need to round off a number to the next highest integer.How can i achieve this?

Thanks
Sikar
 
Sort by date Sort by votes
Local NumberVar RoundUp := 47865.455;
If Int(RoundUp)/2 = RoundUp/2 then RoundUp else Truncate(Roundup) + 1;

Replace the item in bold with your field...

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
482
dgillz
dgillz
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
383
doodledump
D
chish_nc
  • Locked
  • Question
show annivesary dates for next quarter 1
Replies
3
Views
169
chish_nc
chish_nc
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
109
socalvelo
socalvelo
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
287
mmck1964
mmck1964

Part and Inventory Search

Sponsor

Back
Top