Access 2013 IIf #error

[taru]

Status: IIf([Dailyentry Query.Absent]="[Leaveapply.Leavefrom]","OnLeave","Absent")

this query give resut #error
I am trying to compare absent date and leave date from two different table

 

[Grumm]

Maybe you should ask yourself this :

Why do I compare Dailyentry Query.Absent with the word "[Leaveapply.LeaveFrom]" ? Is this what I wanted ?

So I dont know why you added the quotes in the first place, but any text that is between double quotes is just a plain text for Access.

 

[taru]

Thanks Grumm