Dilip and SlimDave,

Brilliant thanks for all your help, I've not tried the NVL function yet will do first thing tomorrow morning.

Thanks again

Al