Omit entry on report where missing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a report with each entry containing 12 fields. What I would like
to do is have the the report automatically not include entries when they are
missing information in one of the fields. Access 2000. Thanks.
 
There is not a great deal of information to go on here, however, if you are
using a query for the Record Source of the report, one alternative is to
constrain each field in the query so that it does not return a record if a
field is Null. This of course assumes you are allowing Null values in these
fields. For example:

SELECT Field1, Field2, Field3, ...
FROM MyTable
WHERE Field1 Is Not Null AND Field2 Is Not Null AND Field3 Is Not Null AND
....

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am running a report with each entry containing 12 fields. What I would
like
to do is have the the report automatically not include entries when they are
missing information in one of the fields. Access 2000. Thanks.
 
Back
Top