if statement with two conditions

[fleurdelisse]

I want to write an if statement testing two conditions.

In particular I want to say:
if date 1<DATE OR date 2<DATE
then field 4 = xx
else field 4 = yy

How can I write that in access (SQL)?

Thanks,