I need to create an expression within the design view of a query.
The expression needs to evaluate to True or False.
The underlying table has four fields of interest. Namely "RegAs", "Regular", "HomePhone" and "CellPhone".
The logic is as follows:
If RegAs = "Hd of HseHold" AND Regular = True AND (IsNot Null HomePhone OR IsNot Null CellPhone) Then bolAllGroup = True
What would be the expression syntax to be coded in the expression builder?
Can I name the expression, like "bolAllGroup"? I.e., I think the default would be something like "Exp1:".
Thanks
Bill