Hi

Thanks for your reply.

Unfortunately it's not my db design. I have just been asked to produce a report from a COTS product and that is how the...