criteria needed in more than 6 fields (1 Viewer)

jedder18

Just Livin the Dream!
Local time
Yesterday, 23:28
Joined
Mar 28, 2012
Messages
135
How do we run a query that has 20+ fields needing a criteria of is not null in each field?
 

plog

Banishment Pending
Local time
Today, 01:28
Joined
May 11, 2011
Messages
11,613
in design view you bring down all the fields you want to show and apply criteria to. In the criteria section beneath each field you put "Is Not Null"
 

jedder18

Just Livin the Dream!
Local time
Yesterday, 23:28
Joined
Mar 28, 2012
Messages
135
IT's only showing 6 levels to put a criteria in...
actually showing 9 levels.
These will be OR criterias.
 

plog

Banishment Pending
Local time
Today, 01:28
Joined
May 11, 2011
Messages
11,613
That's not what your initial post implied.

In that instance I would create a calculated field that tested them, then apply criteria to that caclulated field:

IncludeRecord: Iif(Isnull([Field1]), 1, 0) + Iif(Isnull([Field2]), 1, 0) + Iif(Isnull([Field3]), 1, 0)

Then in the criteria section of that field I would put >0.
 

Users who are viewing this thread

Top Bottom