counting from different tables
 

Hi

I have 3 columns 1 with week number, 1 with rep code i.e. 101 102 103 104
and one with values

How do I count the number of values that pertain to a specific rep and week
number and also how do i return the value that relates to the rep code and
week number

Week Number Value Rep Code
1 £3,200 103
1 £1,000 106
1 £450 104
1 £1,000 106
1 £1,000 102
1 £800 106
1 £500 106
2 £2,000 102
2 £2,200 104
2 £1,230 104
2 £1,000 102

I am trying to insert these values in to a sales tracker by week by number
and value automatically and am having trouble

counting from different tables
 

see response to your later posting

--
Regards
Roger Govier

"Garf" wrote in message
...
Hi

I have 3 columns 1 with week number, 1 with rep code i.e. 101 102 103 104
and one with values

How do I count the number of values that pertain to a specific rep and
week
number and also how do i return the value that relates to the rep code and
week number

Week Number Value Rep Code
1 £3,200 103
1 £1,000 106
1 £450 104
1 £1,000 106
1 £1,000 102
1 £800 106
1 £500 106
2 £2,000 102
2 £2,200 104
2 £1,230 104
2 £1,000 102

I am trying to insert these values in to a sales tracker by week by number
and value automatically and am having trouble