Group by week

[dgrant_jr]

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.

 

[Marshall Barton]

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

Set the report to group on the expression:

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

where Dte is the name your date field.

 

[dg]

Thanks for ending my pain and suffering!!!


D.

Set the report to group on the expression:

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

where Dte is the name your date field.