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

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?
 

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