Custom Grouping

  • Thread starter Thread starter *Glen*
  • Start date Start date
G

*Glen*

I have a table with dates and expenses. Billing cycle starts on on the 24th
of each month, and I need to divide the month into four parts (approx). I
want there to be a header for the week starting date, followed by seven days.
Therefore, the week may start on Wed, 24-Feb and end on Tues, 3-Mar. For
example, I want the report to appear like:

Week Starting Date Expense

24-Feb

24-Feb $10
25-Feb $15
26-Feb $8
27-Feb $23
28-Feb $50
1-Mar $3
2-Mar $13

Week Total $XXXX

3-Mar

3-Mar $30
etc. etc..
Week Total $XXX


I was able to make custom grouping equal to 7 days, but the Access makes the
week start on Sunday. Is there any way I can tell Access to group the days
together the way I want? I know this seems confusing and appreciate any help
than anyone can provide. Thanks!
 
I expect you have a date field which you can simply add or subtract a number
of days. Your Sorting and Grouping Field/Expression might look like:
=[ExpenseDate]+3
 
Back
Top