>My question is how do you send the result of a query to a report. I tried using the print menu and sending it to the name of my report, but all I get out of that is a browse. When I tell it to print to a report and show me a preview the preview is blank,but I have a browse. What am I doing wrong? thanks for all the help.

Ok, let's go through the process. I assume U have an SQL routine that creates a cursor. I also assume that U already have an existing report form (since U tried to preview it). What are your control names on the report form? Do they match the cursor. For example, if you have a cursor named TEMP then your fields on the report would have a name of TEMP.fieldname. Personally, I do not preceed the field names with the cursor/table name. Is this your problem? Do U have the wrong table reference in your fields on the report form? Here is what I would do:
1.) Create the cursor that your report form requires via the command window.
2.) Modify your report form and attempt to preview within design mode.
3.) Does it work?

Also, I remeber a strange problem I had many moons ago, related to a complex string used for footers/headers. Make sure your footers/header groupings are properly created. Remove each one until U determine which one is the problem. Provided that U are using footers/headers groupings. And one last problem was related to a corrupt index. but, this may not be your problem, since U are using the results of an SQL routine. Make sure your ORDER is setup properly in the SQL routine also. Well, I think I am finally awake now. htwh... Steve