counting from different tables

G

Garf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top