easy way to query each field?

[LGarcia]

Hi all,
I have to check all the fields in a table for missing data. The problem is
that there are 60 fields to search. Is there a way to use code instead of
creating 60 different queries?
Using Access2K
Thanks!!
LGarcia

 

[John Vinson]

Hi all,
I have to check all the fields in a table for missing data. The problem is
that there are 60 fields to search. Is there a way to use code instead of
creating 60 different queries?
Using Access2K
Thanks!!
LGarcia

Create one query with sixty criteria: if by "missing data" you mean
null values in the field use

SELECT * FROM yourtable
WHERE field1 IS NULL OR field2 IS NULL or field3 IS NULL or ...

If all fields are required to have data, open the table in design view
(after you've fixed the currently missing data) and set each field's
Required property to True. Then you won't be able to add records with
missing data in the first place, so you won't have to find them!

 

[LGarcia]

Thanks! I'll give it a try. I wish I could set each field as required but my
data entry system has to allow some nulls because our interviewers miss an
occasional question. I don't think there is code to handle that!