Results 1 to 7 of 7
  1. #1
    bburton12@comcast.net is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    11

    Sum of a group of fields per date

    Hello. I'm new to Access reports. I set up a date field with a separate column of numbers that run below it (called the Number Completed). Once I'm done with the Number Completed column for that date, I'd like a sum of the number. Then I have another date field and start over again. I would like the report to show a sum of all of the numbers for each date field.

    So I guess once Access reports detects a new date, it would automatically calculate the sum from the previous date? Sorry, I'm not very organized with this, and I'm not sure how to set this up. Any help would be appreciated.

    Thanks,


    Brad

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,515
    Sounds like you've made the common error of using spreadsheet design in a database. A relational database is not a spreadsheet and should not be designed like one. Search here on normalization. You haven't given enough info about the data being stored for me to suggest a design.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,515
    In case I misunderstood, see if the query does what you want, replacing the names:

    SELECT DateField, Sum(NumberCompleted) AS TotalCompleted
    FROM
    TableName
    GROUP BY
    DateField
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    bburton12@comcast.net is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    11
    That may work, I'll have to work with it. I guess I was hoping I could get Access to work like the Excel sheet. I'll have a look at normalization. Thank you.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,515
    I may have misread the design. Posting the relationships or the fields in the table could clarify matters. My first thought was that you had dates as fields.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    bburton12@comcast.net is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    11
    I need to think about this first and figure some things out before I post again I think. Right now it's just jumbled in my head. Thank you for helping.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,515
    No problem. Hopefully I didn't jump to a false conclusion and confuse the issue.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Test if a group of fields are -1
    By andy49 in forum Access
    Replies: 3
    Last Post: 02-27-2017, 04:56 AM
  2. Replies: 2
    Last Post: 11-26-2016, 01:07 PM
  3. Replies: 6
    Last Post: 06-09-2015, 09:51 AM
  4. GROUP by yet SELECT fields not within GROUP BY
    By johnseito in forum Access
    Replies: 25
    Last Post: 11-03-2013, 10:20 PM
  5. I want to group by the last date
    By offie in forum Queries
    Replies: 3
    Last Post: 07-22-2013, 02:50 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