Results 1 to 3 of 3
  1. #1
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283

    Adding decimals in Dcount


    Hello,

    I am building a query from my table(Table1) and I have records of number of hours worked in a fixed number format. I want to add them all up to a total but when I use the count option in the group by it just adds them to a whole number. I want to keep the 2 decimal places. Can you do this with the DCount function or is there a better way? thanks

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Count will count the number of records. I think you want Sum.

  3. #3
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283
    Wow that was a dumb question by me..thank you!

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

Similar Threads

  1. Include Decimals when Adding Fields
    By janmack79 in forum Queries
    Replies: 3
    Last Post: 04-24-2017, 02:01 PM
  2. Subtraction with decimals
    By UT227 in forum Queries
    Replies: 3
    Last Post: 04-06-2017, 07:25 AM
  3. Rounding decimals
    By brianmcleer in forum Access
    Replies: 1
    Last Post: 06-05-2013, 12:37 PM
  4. Age with Decimals?
    By Lowell in forum Access
    Replies: 1
    Last Post: 10-18-2012, 11:13 PM
  5. Replies: 6
    Last Post: 06-01-2012, 03:51 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