Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2012
    Posts
    3

    Question Unanswered: average query shows too many decimals help.

    Hi I am a noob with access so sorry if this is elementary but....
    The columns that the query is using to get average of from is set to show/store only 2 decimal places but the result is giving a number with 18 decimals. How do I make it so the query only generates numbers with 2 decimals. I am a noob but am pretty familiar with the basics, any help would be greatly appreciated!

  2. #2
    Join Date
    Sep 2012
    Posts
    3
    also related.... In my query I have 2 avg colums and i want to create another column that shows the difference between the 2 avg columns in the same query for each row. How to?

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    First part - use the Round function to control how many decimal are returned for your average values.
    Second part - use the Sum function on your two averages, rounding the result if need be.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  4. #4
    Join Date
    Sep 2012
    Posts
    3
    ahh. the problem must be that I am using the query wizard.....

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    No
    There is no problem with the query wizard
    The problem if it exists is with your query or you are not setting the correct format in your form or report. Leave the query as is, but change the display format in the relevant control on the form
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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