Thanks that seems to help. But I was just wondering what I could do to help speed up the retriving of the view. I am simple retrieving information for one customer - I have an index based on that field but that doesn't seem to help the executing the view. The recordset if around 120,000 records. Any idea if any that I am doing incorectly.