Access Date Prompt in Query
Posted on 2013-01-11
What I'm trying to do is that if the enter date is greater than or equal to [Entry Exit Exit Date], then result be "Yes" if not "No".
When I try the expression as is, I get no data results.
[Enter Reporting End Date]
End of Report Period is: IIf([Enter Reporting End Date]>=Format([qrySHOFamilySystemB]![Entry Exit Exit Date],"Short Date"),"Yes","No")