if statement with two conditions

F

fleurdelisse

Joined
Jul 13, 2010
Messages
1
Reaction score
0
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query using more than one equation for a field calc 1
Between ...And 4
Query Criteria Error message 6
Using an IIF Statement to calculate discharge date 4
Iif Statement based on 2 conditions 2
#error - Blank 3
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
iif statement 4

Top