Referencing Column names

[Runawaygeek]

I think i get what you mean by one giant table, add the weights to Tasks,

TASKA, TASKB, TASKC, WEIGHTA, WEIGHTB, WEIGHTC

Then i could build anything, like IIF(ISNULL(TASKA),"",TASKA*WEIGHTA)

This might be the winner, also if i crosstab it, i could then have the Weight Table made easy for updating if required?

 

[sneuberg]

I think i get what you mean by one giant table, add the weights to Tasks,

Who said anything about a giant table. Did a post get deleted?

 

[Runawaygeek]

I assumed thats what you meant by:

If you restructured this into a single table with the column headings being field values I think I would be possible.

I think its a winner anyhow, it means i can keep the current Table and form for tasks, have a table that lists the Tasks and their weighting.
the link is automated, which makes the output dynamic.

I just need to map them to my other data now. ill keep you posted!

 

[Runawaygeek]

Hi Steve,

Just wanted to thank you for all your help, talking through it and your ideas have really helped me. I have tested 5 tasks for weighting now and they all work and I already have a Sum score buy affiliate. I just need to write in the 30 left over rules and its done!
Thanks again.
B