Thanks for your reply Hilmar,

I need a query like this for both on-screen, as well as report generation.
I've tried out Borislav's code and it works. However, would you be able to specify how one can use report variables to create the same situation within a report?

Regards,

Steve.