Results 1 to 3 of 3
  1. #1
    baarrnnee is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    3

    Weekly, Monthly and Yearly summaries on a report

    Hello all;

    I have a database that weekly donations are entered in 10 different categories.

    Donations from individual members are recorded each week on the Sunday date of the week.

    I want to be able to run a report that will show me weekly, monthly and annual totals on one sheet in each category.

    I have tried running a query and report that gives me either the whole month's totals and yearly without the weekly totals, or I can get the weekly totals and don't know how to get totals for the month or year added up on this report.

    Any help would be appreciated.



    Karl

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Suggest you do 3 queries and 3 subreports based on these queries
    Modify table & field names to match your database

    a) Year
    Code:
    SELECT Year([DonationDate]) AS DonationYear, Sum(tblDonations.Donation) AS TotalDonations
    FROM tblDonations
    GROUP BY Year([DonationDate]);
    b) Month (gives month number)
    Code:
    SELECT Month([DonationDate]) AS DonationMonth, Sum(tblDonations.Donation) AS TotalDonations 
    FROM tblDonations
    GROUP BY Year([DonationDate]);
    c) Week
    Code:
    SELECT DatePart("ww",[DonationDate]) AS DonationWeek, Sum(tblDonations.Donation) AS TotalDonationsFROM tblDonations
    GROUP BY DatePart("ww",[DonationDate]);
    NOTE: If your reports will span more than one year you should include Year([DonationDate]) in each query
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    9944pdx is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2011
    Location
    PDX
    Posts
    44
    excellent. thanks.

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

Similar Threads

  1. Weekly or monthly reports on Access
    By duddu in forum Access
    Replies: 2
    Last Post: 09-23-2017, 11:40 PM
  2. Monthly report with weekly totaSs
    By Alex Motilal in forum Reports
    Replies: 3
    Last Post: 09-27-2015, 10:26 AM
  3. Query monthly or yearly using combo boxes
    By Swatskeb in forum Queries
    Replies: 4
    Last Post: 11-03-2014, 06:21 PM
  4. Replies: 2
    Last Post: 03-19-2014, 08:03 PM
  5. Is weekly / monthly automation possible?
    By 10 Gauge in forum Access
    Replies: 4
    Last Post: 03-17-2011, 07:23 AM

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