erm..... I dont know what to say, other than OMG! THANKYOU EVER SO MUCH!
You dont know how long ive been on this.
I have tried many shared variables, sub reports, allsorts, but to no avail.
You have just finalized my report, that will be heavily used in my company.
I cannot thank-you enough.
It has certainly been a learning curve this one, and I now have the knowledge to implent this solution in other reports.
Sincere gratitude to you.
Anything i can do for you, just shout. anytime.
:)
Happy Mike.