When I run my query and send it to a report and have a secreen preview, I don't get the results of my query in the report I get the whole database. What am I doing wrong.It seems that it is sending it to a temporary cursor instead. What can I do? This was a rather easy task in 2.6 why is it so hard in 3.0. Anyway thanks for all your help.