|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 22nd, 2004, 03:35 PM
|
|||
|
|||
Group by week
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. -- 
|
|
#2
November 22nd, 2004, 05:56 PM
|
|||
|
|||
|
dgrant_jr wrote:
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. -- Marsh MVP [MS Access]
|
|
#3
November 23rd, 2004, 09:23 AM
|
|||
|
|||
|
Thanks for ending my pain and suffering!!!
D. "Marshall Barton" wrote in message ... dgrant_jr wrote: 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. -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Grouping by date - How To: Show the first day of the week instead of the first date entered in that week... | Neil | Setting Up & Running Reports | 4 | October 8th, 2004 10:56 AM |
| Grouping by both Month and by Week in a Pivot Table | Gordon | General Discussion | 1 | August 21st, 2004 12:36 PM |
| Using the "Group By" box to group by date sent | Keith Brown | General Discussion | 0 | August 18th, 2004 03:25 PM |
| Group Naming | Group Me | Outlook Express | 1 | August 9th, 2004 05:52 AM |
| Help Needed for Groups Please | Paul Black | General Discussion | 15 | June 21st, 2004 02:54 AM |
Linear Mode
