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