Thanks for the suggestion Nadya. The SQL result is what I'm looking for but unfortunately, I have to get the results from a buffered view and so it seems as if I'm no further ahead! Sigh....