Table with fields with no data

[Tony Williams]

I have a table that has a number of fields where the data is shown in View
for some records as an empty cell, presumably Null. In some cases there is
either data or zeros. I think this is because these are new fields that have
been added some time after the database was created. Can I write a query
that searches all the records and fields in the database and returns only
those records and fields where these odd fields are empty? And of course if
so what would be the criteria for the query.
Thanks
Tony

 

[Arvin Meyer [MVP]]

The criteria would be (in the field that is empty, of course)

Is Null

 

[Tony Williams]

Thanks Arvin
Tony

The criteria would be (in the field that is empty, of course)

Is Null
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Tony Williams]

Arvin, is there anyway of running a query and reporting ALL fields and
records that have a NULL value rather than checking each field individually?
Tony

 

[Arvin Meyer [MVP]]

Sure, you OR them.

Add Is Null to your first criteria, drop down to the second criteria box for
the next field, etc.

If your purpose is to identify the records, that works well, but if you want
to fix them, it is better to work on 1 field at a time to avoid confusion.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com