'If' and 'And' statements

[jak26]

Hi
Hopefully someone can help here.

How do you get an 'if' function to evaluate two statements and if both are satisfied then return the correct answer?

I am most familiar with excel which would be:
=if(and(statement1,statement2)>statement3,answer if true,"")

In access I have:

If(statement1 And statement2, answer if correct, "")


Hours: IIf([Start Date Time]<=[ORCA_LABOUR_GROUP_MEMBER]![START_DATE] And [ORCA_LABOUR_GROUP_MEMBER]![END_DATE]>[End Date Time],
([End Date Time]-[ORCA_LABOUR_GROUP_MEMBER]![START_DATE]*24),"")

Any help appreciated

Jeff

 

[LxQ]

I put this in, and it worked for me.. what kind of problem do you have with it?

Edit:
actually, I haven't checked the calculation.. you need a paranthesis for your calculation:
(([End Date Time]-[ORCA_LABOUR_GROUP_MEMBER]![START_DATE])*24

 

[MNpoker]

You need to put the qualifier in each part of the AND statement.

If(And(statement1>Statement3,Statement2>Statement3), answeriftrue, false)