Creting A Report For Missing Values?

[Israel Rodriguez]

I'm tring to set up a report, via a query, that shows records that
have a particular value missing.
Any ideas?

Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/

 

[gandalf]

Missing is a bit vague

If you mean a NULL value you must query ... IS NULL
instead of = NULL

 

[Cheryl Fischer]

Here is a link to one solution:

ACC: How to Flag Out-of-Sequence Numbers on a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;137118


hth,

 

[Israel Rodriguez]

Missing is a bit vague

If you mean a NULL value you must query ... IS NULL
instead of = NULL

Thanks, that worked.
What I was looking for is that when a record was created, to track if
info is miisng from a particular field, and this is good for tracking
one field.
Is there a way to do it for more than one field, as in displaying
records where either one filed or another is missing a value rather
than making separate query's for each missing vaule?

Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/