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
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