Table with fields with no data

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

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, 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
 
Back
Top