Very complicated report to go with a very complicated query....HEL

  • Thread starter Thread starter ReportTrouble
  • Start date Start date
R

ReportTrouble

Ok this is very tough I dont even know if it's possible:

I have a query that displays the 'action' of each person, and I need a score
for each person which sums up total 'action'...

Example of the query:
NAME LINK ID CLICK COUNT REQUEST FOR INFO
TOM A 1
B 2
GREG C 1
request email
A 2

SO... Tom should have a score of 3 because each click count is 1 ([1+2]x1)=3

AND Greg has a a score of 8 because he has 3 click counts...AND if he has
'REQUEST FOR INFO' he automatically gets 5 extra points ([1+2]x1+5)=8

So I need a report to generate a Total score for each person because I have
300+ people...

Please let me know if this is possible and if so...how?
 
Back
Top