Printing Forms, Prints Every Other Page

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I have an access report that uses lable wizard to print
address' on NCR Pin Fed forms. The problem is each address
prints on every other page.

This normaly happens to me when a report is larger than
the paper and skips every other page when printing. This
time the label is small 3 X 2 and the page is a custom
form size 5.5 X 8.5. The Left margin is set at 2.5 inch
Rignt margin is .33 Top set at 7.5 and bottom is set
at .20 What might be the problem? Below is the SQL for the
Report.

SELECT A_RXUSE.[Account Name], A_RXUSE.Address,
A_RXUSE.City, A_RXUSE.State, A_RXUSE.Zipcode, A_RXUSE.
[Phone Number], [A_RXUSE]![Number of RX's]*[Pct]+[A_RXUSE]!
[Number of RX's] AS [Rx X Pct], -Int(-[Rx X Pct]) AS Qty,
A_RXUSE.[Account Number], A_RXUSE.[Number of RX's]
FROM A_RXUSE, [Range Pct]
WHERE (((A_RXUSE.[Account Number]) Between [START ACCOUNT
NUMBER] And [END ACCOUNT NUMBER]) AND ((A_RXUSE.[Number of
RX's]) Between [MinNum] And [MaxNum]));

Thanks Dennis
 
I seriously doubt that the query of this report is causing a formatting
issue.

Double check all of the settings in the report designer, paying close
attention to the margins, first.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top