Omitting records with empty fields

D

Diane

How do I set up a report where I want to view a list with certain fields
containing a value to print? If that field is empty, I would like the report
to skip that name.
 
D

Dennis

Base your report on a query, set the criteria for the field in your query to
Is Not Null
 
S

Stockwell43

Hi Diane,

In your query, try putting Is Not Null in the criteria portion of the field
you don't want to show if the field is empty.
 

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