Jason - you really are a star! Thank you so much for such a helpful, considerate post. I have to apologise; had I really taken the time to...

wolfkillj (12/23/2013)

---

sneilson (12/23/2013)

---

The actual stored procedure is quite complex but essentially is picking up a money field multiplying by a decimal (23,10) and then calculating a percentage by multiplying by...

The actual stored procedure is quite complex but essentially is picking up a money field multiplying by a decimal (23,10) and then calculating a percentage by multiplying by an integer...

Thank you so much for this - schoolboy error but so easily done!:-)

Can you help me too with setting the parameters. We don't have a default parameter that can be assigned, but need to use a field from the previous step...

I have a similar issue I think - and really struggle with the principle of scope being a part time developer! I have a matrix that shows the last...