Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Grouping Between Dates

    I feel Like I have to re-learn this every couple of months so I apologize if I have asked this before.



    (side note: any Idea why I can only find my last 4 posts on this forum??


    anyway the qry has basic transaction data

    Deposit/Withdraw Category Amount and Date

    now I need the data between two specific dates so I have to have the date column but I have it not shown
    and even when group by type,
    group by category
    sum by amount

    it still displays all of the transactions individually

    Click image for larger version. 

Name:	QryDesign.PNG 
Views:	13 
Size:	27.9 KB 
ID:	44580
    Click image for larger version. 

Name:	qrydisplay.PNG 
Views:	13 
Size:	16.6 KB 
ID:	44581

    Thanks for the help

  2. #2
    JoeM is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3,904
    It is because you have "Group By" under your TransDate column. Even though you are not displaying the dates, you are telling it to group by dates.
    Change the "Group By" to "Where", so it is treated as Criteria only.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    (side note: any Idea why I can only find my last 4 posts on this forum??
    Click on your username in this post, then view forum posts. All 114 of them are there?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 1
    Last Post: 05-19-2020, 12:11 PM
  2. Grouping Data by dates
    By chr1stoper1 in forum Access
    Replies: 5
    Last Post: 01-17-2017, 02:26 PM
  3. Grouping and dates
    By loonytoons in forum Queries
    Replies: 4
    Last Post: 02-24-2015, 10:28 AM
  4. Replies: 3
    Last Post: 06-27-2013, 10:18 AM
  5. Grouping Columns with dates
    By gauravnagpal in forum Access
    Replies: 6
    Last Post: 04-10-2012, 06:03 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