Conditional field

Timberwolf

Registered User.
Local time
Today, 21:02
Joined
Dec 15, 2000
Messages
33
I have four yes/no fields in a table, and in my query I would like to create another that is checked if any of the other four are checked.

Any help would be appreciated. Thanks!
 
IIf([Field1]=True Or [Field2]=True Or [Field3]=True Or [Field4]=True,True,False)
 
Create a calculated column in your query. Then use a formula like this to make it True if any of the other four are true:
Code:
MyNewField:[field1] Or [field2] Or [field3] Or [field4]
 

Users who are viewing this thread

Back
Top Bottom