Thanx, folks, for your advice...

I finally cracked it using Dynamic SQL .. works a treat.

Thanx again.

Joe

Thanx for that.

I must admit that the same idea had occurred to me, but shyed away from trying it as the tables concerned are HUGE and I had doubts that...