Hiding Blank Labels

I

iholder

I am printing labels on 20 labels sheet. Occassionally a blank record is add
to to the table causing the blank label on the first label of the sheet.
This causes the 20th label to print on a second sheet.

What can I do to prevent this from occcurring.

Thank you.
 
D

Duane Hookom

Set the report's record source to a query that restricts records to non-null
values.
 
D

Duane Hookom

You would change the report's sql to something like

SELECT *
FROM tblYourTable
WHERE LastName is not Null;

--
Duane Hookom
MS Access MVP
--

iholder said:
Could you send me a example. Fields in the query are [LastName] and
[FirstName]


Duane Hookom said:
Set the report's record source to a query that restricts records to
non-null
values.
Click to expand...
Click to expand...
 
Top