Blank Entries In report

D

Dave

Hi
Hope someone can help me. I designed a report to make labels and there are
some blank entries in my database, that I do not want to be included how do
I leave these out of the report.
Example

Last Name/ First Name /Address/ City /State /Zip/ Total /Acers/ Price/
Buildings /

if the Last Name is missing in the report I would like it not show up in my
report to make labels.
Thanks
Dave
 
M

Marshall Barton

Dave said:
Hope someone can help me. I designed a report to make labels and there are
some blank entries in my database, that I do not want to be included how do
I leave these out of the report.
Example

Last Name/ First Name /Address/ City /State /Zip/ Total /Acers/ Price/
Buildings /

if the Last Name is missing in the report I would like it not show up in my
report to make labels.

Use a query as the report's record source. Set a criteria
to only select the records that have something in the last
name field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top