T taru New member Local time Yesterday, 23:17 Joined Apr 12, 2016 Messages 2 Apr 12, 2016 #1 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
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
G Grumm Registered User. Local time Today, 08:17 Joined Oct 9, 2015 Messages 395 Apr 12, 2016 #2 Maybe you should ask yourself this : Why do I compare Dailyentry Query.Absent with the word "[Leaveapply.LeaveFrom]" ? Is this what I wanted ? Click to expand... 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.
Maybe you should ask yourself this : Why do I compare Dailyentry Query.Absent with the word "[Leaveapply.LeaveFrom]" ? Is this what I wanted ? Click to expand... 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.
T taru New member Local time Yesterday, 23:17 Joined Apr 12, 2016 Messages 2 Apr 12, 2016 #3 Thanks Grumm