Hi Marvin,

Thanks for your reply.
I tried using Pivot Tables before writing this query but they did not quite work. Fortunately I figured a way out and its all good now.

Thanks for your help anyway.

Thanks,
BJ