Results 1 to 3 of 3
  1. #1
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55

    Creating a weekly report


    Hi Guys

    What would be the best way to set up a query to return sums and amounts on a weekly report. The week in this case being Monday up to Sunday.
    The report would have to be week on week .I'm not using code yet but was wondering if there was a simple way to do this without code?
    Thanks in advance

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    create a form
    save the form as 'frmreportsetup'
    put two text boxes on the form
    name the two text boxes 'startdate' and 'enddate'

    in the query driving your report on the date field in question put the criteria

    between [forms]![frmreportsetup]![startdate] and [forms]![frmreportsetup]![enddate]

    run the query to verify your results.

  3. #3
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55
    great works a treat thanks

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

Similar Threads

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