Results 1 to 2 of 2

Thread: rounding down

  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: rounding down

    I'm creating a query that's suppose to round down a set of numbers to the nearest 500. All I'm able to do so far is round up or down to the nearest 500 using the following code.

    roundednumber: 500*CInt([originalnumber]/500)

    How can I make sure this rounds down and not up and down to the nearest 500?

  2. #2
    Join Date
    Jun 2002
    Posts
    173
    i figured it out. Just used "int" instead of "cint". Maybe this will help someone else who was wondering the same thing.

Posting Permissions

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