Results 1 to 3 of 3
  1. #1
    gauja is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    4

    Format numbers

    I want to format number so so it do not rise the number to nearest whole number like rise 10,6 to 11 but keep it as 10. How would that be done.


    Gauja

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    Use Int(FieldName)

    Here is a quick tutorial

    http://www.techonthenet.com/access/f...umeric/int.php

    Alan

  3. #3
    gauja is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    4
    Thanks Allan
    Thats solved
    Gauja

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Textbox and numbers
    By GraemeG in forum Forms
    Replies: 1
    Last Post: 03-16-2011, 06:05 AM
  2. Duplicating numbers....why??
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 01-21-2011, 01:32 PM
  3. numbers
    By Balen in forum Access
    Replies: 1
    Last Post: 08-17-2010, 05:16 PM
  4. Format decimal numbers with fixed width
    By Persist in forum Programming
    Replies: 5
    Last Post: 07-14-2010, 05:43 PM
  5. Random numbers
    By Gator777 in forum Access
    Replies: 3
    Last Post: 08-12-2009, 10:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums