Query Problem

[Steve]

Hi,

I am looking for a query to take 7 different fields, and produce a result if
ANY of the 7 fields are blank. If I use the "Is Null" function in each
field, it doesn't work because the query looks at that and says that ALL the
fields have to be blank to provide a result. Does anyone have any idea on
how to do this??

 

[Duane Hookom]

Try:

SELECT *
FROM [unnamedtable]
WHERE fld1+fld2+fld3+fld4+fld5+fld6+fld7 Is Null;

 

[Daryl S]

Steve -

If you use a different row criteria for each 'is null' criteria, this will
work. This means put the Is Null for the first of seven fields on the first
criteria row. Then put the Is Null for the second field on the second
criteria row. The criteria rows are 'OR', while all the criteria on one row
is considered 'AND'.