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

CEIL FUNCTION

  • Thread starter Thread starter giben3
  • Start date Start date
G

giben3

Guest
Please...can any one help me ?


How can i use the "ceil()" function in relations? Im trying to use this function


with this way " ceil(d1) " and give me wrong.
 
What is it giving you? (A whole number?)

If you use this syntax, you can control number of decimal places:

ceil(d1,2)
This would round to 2 decimal places
 
Yes... i know..with this syntax " ceil(d1) " it must give me an integer number. But itgiving tome "errorLogical expression expected".


smiley19.gif
 
Try putting & in front of the d1.
 

Part and Inventory Search

Sponsor

Back
Top