The Great One
Thread Starter
- Joined
- Sep 27, 2001
- Messages
- 89
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
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