Results 1 to 3 of 3
  1. #1
    bronson_mech is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    94

    Weekly Report


    Gents,

    is there any way to group by week.......

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    if by your very brief question you mean you have a date field which you want to convert to a week, then yes - use the datepart function to group on - see this link https://www.techonthenet.com/access/...e/datepart.php

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a form with 2 text boxes, txtStartDate, txtEndDate.
    make a query to pull the data based on the range of the 2 boxes.
    select * from table where [MyDate] between forms!myForm!txtStartDate and forms!myForm!txtEndDate

    i have also added quick pick radio buttons to fill in the boxes faster. (see photo)
    Click image for larger version. 

Name:	reports.png 
Views:	8 
Size:	13.7 KB 
ID:	27109

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

Similar Threads

  1. Creating a weekly report
    By chr1stoper1 in forum Reports
    Replies: 2
    Last Post: 05-12-2016, 10:41 PM
  2. Monthly report with weekly totaSs
    By Alex Motilal in forum Reports
    Replies: 3
    Last Post: 09-27-2015, 10:26 AM
  3. weekly timetable report format
    By merlin777 in forum Reports
    Replies: 14
    Last Post: 10-27-2014, 11:06 AM
  4. Replies: 2
    Last Post: 09-19-2014, 04:29 PM
  5. Creating Weekly report from Cumulative Totals
    By Sackface in forum Access
    Replies: 3
    Last Post: 03-14-2013, 11:17 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