Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Unanswered: Convert Double To Upper Number

    Hi I was trying to Round a double number to Upper Number.
    For Example,
    If The Number is 1.3 I want to round it to 2 .
    If i use Fix() function it rounds it 1.

    Any Help will be appreciated.
    Thanx in advance.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    try:
    Code:
     intUp = IIf(Round(dblVar) >= dblVar, Round(dblVar), Round(dblVar) + 1)
    izy
    Last edited by izyrider; 07-05-03 at 04:47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •