Thanks for your quick response that has helped no end stopped me from heading in the wrong direction anyway. Any suggestions on optimising the performance when querying this view?