Adam,

Stop the debugger between the time your data is selected and the report is PREVIEWed or PRINTed. Make sure that you have SELECTed the correct data and that there are the correct number of records.

Then check to see which table is the current work area when you print your report. My guess is that somehow you are moving to another work area. Put a breakpoint on SELECT() which will stop every time the work area changes and step through that part of the code.



>I'm using SQL SELECT to gather the data for a report. Everything comes up just fine in Preview, but when I send it to the printer, I only get one record from the middle somewhere (not the first or last record).
>
>I have found that if I bypass the PREVIEW and send it directly TO PRINTER, everything comes out the way it should.
>
>I will point out that the query is created in a form which then runs the REPORT FORM rather than having the query directly in the Report environment.
>
>Adam