Group by week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi there

I am trying to create a report which groups on the week ENDING date. In
addition to do this i need to total a number of values for the 7 days prior
to that week ending date. This is based on a table which would contain the
daily sales figures.

eg.

week ending Total Sales
7/11/04 £1000.00
14/11/04 £999.99
21/11/04 £12345.00


Thanks in advanced

d.
 
dgrant_jr said:
I am trying to create a report which groups on the week ENDING date. In
addition to do this i need to total a number of values for the 7 days prior
to that week ending date. This is based on a table which would contain the
daily sales figures.

week ending Total Sales
7/11/04 £1000.00
14/11/04 £999.99
21/11/04 £12345.00
Click to expand...

Set the report to group on the expression:

=Dte + 7 - DatePart("w",Dte,2)

where Dte is the name your date field.
 
Thanks for ending my pain and suffering!!!


D.


Marshall Barton said:
Set the report to group on the expression:

=Dte + 7 - DatePart("w",Dte,2)

where Dte is the name your date field.
Click to expand...
 
Back
Top