Monthly report

[Alex Motilal]

I would like to generate Monthly report with Week as subtotals. The first day of the week should be Sunday. For example, the report for the Month of June, 2018 should be as below:

For the 1^st Week data should be for 1^st & 2^nd Dates (Since the 1^st day is Friday) and the Subtotal on 1^st Week (ie, total for 1^st & 2^nd dates)

For the 2^nd Week data should be for dates from 3^rd to 9^th and the Subtotal on 2^nd Week
And so on till the 5^th Week.


Is it possible & if so I require the guidelines.



Alex

[ranman256]

make a form with 2 text boxes, txtStartDate, txtEndDate.
user fills in the dates.

make a query to pull your data using these dates, qsDateRngData :
select * from table where [DateFld] between forms!myForm!txtStartDate and forms!myForm!txtEndDate

now make a report that uses this query, qsDateRngData

I made my form set the dates using controls (or enter manually):

[pbaldy]

You can add a "last day of week" field to your query so you can group/sum on it in the report. Something like:

DateAdd("d",7-Weekday(DateFieldName,1),DateFieldName)