I want to use if condition like we do in ms excel. Problem is it has two conditions

[ajay parmar]

problem is if and cannot be used in acess, correct me if i am wrong. situa tion is: i have got duration field in sec and some codes like 1,2,3,4 seperately. wantto put the condition:-
if my durationl is less than 11 sec and code is 1 , i should get the count of mobiles having 1 as code and duration less than 11 sec.
same goes for all codes like 2,3,4 with duration less than 11.
also, need to calculate count of mobiles wih all codes but this time with more than 11 sec

[NeoPa]

I can say little as there is so much missing from the question (like useful information). You are probably looking at the IIf() function though. Within the first parameter (which is the check) you can specify multiple checks using parentheses and joining words like And and Or.

EG.

IIf((X = 0) And (Y = 2), True, False)

I have no real information about the data you're working with so this will have to do for now.