Hey guys
Need some help...im all brain dead trying to figure this out. I have
a table that has the following(dummy date and table)
Date person_ID pens_bought
19/10/2004 t15 50
21/10/2004 t15 150
19/10/2004 t15 70
21/10/2004 t20 20
29/10/2004 t20 100
In my report i want it to display like this:
T15-----------
17th-23rd 200
T20------------
17th-23rd 90
24th-30rd 100
U probably see the few problems:
-first the dates are checked to see what week they fall in. Then the
pencils bought total is calculated for each person for the week.
basically 2 kinds of grouping: grouping for the week and for the ID.
I am completely lost:
Ohh and im using access 2003
thx all...its quite urgent so please help
Jkainth
Need some help...im all brain dead trying to figure this out. I have
a table that has the following(dummy date and table)
Date person_ID pens_bought
19/10/2004 t15 50
21/10/2004 t15 150
19/10/2004 t15 70
21/10/2004 t20 20
29/10/2004 t20 100
In my report i want it to display like this:
T15-----------
17th-23rd 200
T20------------
17th-23rd 90
24th-30rd 100
U probably see the few problems:
-first the dates are checked to see what week they fall in. Then the
pencils bought total is calculated for each person for the week.
basically 2 kinds of grouping: grouping for the week and for the ID.
I am completely lost:
Ohh and im using access 2003
thx all...its quite urgent so please help
Jkainth
