Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    Non programer needs help in decimal numbers

    I have been trying to add fields with decimal number. Except it always rounds-off to near 10th. How do I format the field to write 1.5 and don't round off to 1. Many thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What type of number field do you have? Integer fields will drop the decimal value. You need single, double or maybe currency.

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

Similar Threads

  1. Insert Dash between set of Numbers
    By Jhankish in forum Programming
    Replies: 2
    Last Post: 04-19-2007, 08:02 AM
  2. HELP!!! - Importing table decimal field truncating
    By Valeda in forum Import/Export Data
    Replies: 0
    Last Post: 12-05-2006, 04:06 PM
  3. Replies: 1
    Last Post: 06-09-2006, 05:44 PM
  4. When Week Numbers Collide!
    By Schwagr in forum Queries
    Replies: 3
    Last Post: 03-18-2006, 10:06 PM
  5. Get the sum of decimal values - weird results
    By BengtCarlsson in forum Queries
    Replies: 2
    Last Post: 02-10-2006, 04:29 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
  •  
Other Forums: Microsoft Office Forums