Results 1 to 6 of 6
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    output of queries like to have rounded numbers

    There does not seem to be a simple, obvious way, to round you output of a query:

    I am getting numbers like this:
    25.3175999112427

    And rather have a number like this:
    25.32

    Sometimes I am doing a sum on a field.
    Or if I am just query dumping a field.

    I need a simple format process for output of my queries.



    Thank you Russ - Rneuman at Scaninc.org

  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,923
    Have you tried using the Round() function?

  3. #3
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    rounding process getting a syntax error

    attached.
    Russ

  4. #4
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    The image is too small to be seen.
    Pls quote the exact query expression of the field which cause the error.

  5. #5
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    syntax error on the round function

    please see attached picture snapshot it is now much clearer.

    Thank you
    Russ

  6. #6
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    471x354 is still too small.
    At Least 800x600 in image size
    Copy by Windows Print Screen Function and paste it to PaintBrush (pbrush.exe) for saving it to gif or jpg format
    so that the words could be readable.
    Last edited by thhui; 05-30-2009 at 05:46 AM.

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

Similar Threads

  1. Suming Positive Numbers Only
    By jbarrum in forum Access
    Replies: 5
    Last Post: 04-24-2009, 03:51 PM
  2. vba code for regression analysis P value output
    By Frangipani in forum Programming
    Replies: 0
    Last Post: 02-04-2009, 06:26 AM
  3. Non programer needs help in decimal numbers
    By Peter O in forum Access
    Replies: 1
    Last Post: 10-07-2008, 12:29 PM
  4. Output Query to Text
    By denileigh in forum Queries
    Replies: 1
    Last Post: 05-27-2006, 12:34 PM
  5. How to output only current record in query
    By mslieder in forum Access
    Replies: 0
    Last Post: 01-20-2006, 05:48 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