Omitting records with empty fields

  • Thread starter Thread starter Diane
  • Start date Start date
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.
 
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

Similar Threads

empty field 2
Canshrink question!! 2
blank fields on a name line 2
How to NOT print an empty field 1
Skip records where a field is blank 5
not printing empty fields on labels 1
Empty report fields 1
Updating a bound control on a report 8

Back
Top