Group by week

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.
 
M

Marshall Barton

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.
 
D

dg

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display a weekending date even if there is no data 5
Running total by group 1
Adding prompt responses as as a field value 3
Week to Date Sales 6
Previous Week Ending Date 2
Payroll 1
Running Sum Over Group-doesn't work 1
Excel check if dates are under a range of week 4

Top