how to combine IIf statement in query

[xiaodan86]

I wish to performed some calculation if the condition meet.
If there is more than one iif statement to be include, how can i
combine together?

for example:

Minutes: IIf([start]>DateAdd("d",-1,[forms]![datedaily1]![date] And
[end]<[forms]![datedaily1]![date]),DateDiff("n",[start],[end]))

Minutes: IIf([start]<DateAdd("d",-1,[forms]![datedaily1]![date] And
[end]<[forms]![datedaily1]![date]),DateDiff("n",DateAdd("d",-1,[forms]!
[datedaily1]![date]),[end]))

how can i combine this two statement in one field in the query?

 

[Jeff Boyce]

IIF() statements can be embedded, something like:

Minutes: IIF('a is true', "b",IIF('c is true', "D", "E"))

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/