Blank Entries In report

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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.
Click to expand...

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.
 
Back
Top