Week Commencing

[The Great One]

An example is probably the best way of doing this so here goes....
Every day my department spend different amounts of money on their lunch. What I want to do is calculate how much they have spent over the week (I do this summary every year).

An example of the data I have is

Name Date Of Purchase Cost

Bart 13/12/2001 £10

Lisa 14/12/2001 £8

Homer 14/12/2001 £50

Marge 17/12/2001 £10

Maggie 17/12/2001 £4

Homer 18/12/2001 £45

Marge 25/12/20001 £12
****************************************
What I Want It To Show

10/12/2001(Week Commencing) £68

17/12/2001(Week Commencing) £59

24/12/2001(Week Commencing) £12

Does Anyone Know How To Do This!!!??


Thanks

The Great One

 

[THoey]

What are you doing this in? If it is in MS Access, I would suggest you look at the DATEPART function (especially the "ww" code). You could probably do a GROUP BY where the Date Of Purchase is in the week. Look it up and play with it and if you still need help, post back...

Hope that helps...

 

[Rockn]

Easier to just set up a spreadsheet with each person on a seperate tab. Set up weekly blocks and and columns for the money spent with a total at the bottom. You can set up a sheet for an entire year and update it as needed.