Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
91 Posts
Discussion Starter · #1 ·
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
 

·
Registered
Joined
·
3,458 Posts
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...
 

·
Registered
Joined
·
21,875 Posts
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.

 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top