Results 1 to 2 of 2
  1. 09-01-2010, 01:45 AM #1
    giladweil
    giladweil is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    10

    Unhappy rounding digits

    How Do I round the last two digits in a column of integers?
    Reply With Quote Reply With Quote
  2. 09-01-2010, 03:11 AM #2
    NoellaG's Avatar
    NoellaG
    NoellaG is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,043
    Hi,

    = Round(MyNumber/100,0)*100

    greetings
    NG
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. format number filed to significant digits
    By stileguru in forum Reports
    Replies: 3
    Last Post: 08-13-2010, 01:26 PM
  2. Report query by digits
    By The Phil in forum Reports
    Replies: 4
    Last Post: 04-23-2010, 11:52 AM
  3. Rounding problem
    By jgelpi16 in forum Queries
    Replies: 1
    Last Post: 04-06-2010, 10:27 AM
  4. Rounding off
    By Alex Motilal in forum Access
    Replies: 4
    Last Post: 12-20-2009, 12:47 PM
  5. Left function with various lenth of digits
    By mohsin74 in forum Queries
    Replies: 0
    Last Post: 07-10-2007, 02:00 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums