Hey anthony thanks for the reply. The query works fine but I was just curious about the with clause as I have never used it before. can you through some light on it please. Thanks