Excellent - works perfectly! The table will expand to several thousand records and the query executed every few seconds or so therefore efficiency is very important.

Thank you kindly to...

Hi Chris,

Thank you kindly for your interest/reply...

To make it clearer,

I need the query to return a set of values which includes Id1 and Reference where the Status value =...