<div>
<div class="content wysiwyg-content">
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 &quot;Yes&quot; if not &quot;No&quot;. <br />
<br />
When I try the expression as is, I get no data results. <br />
<br />
[Enter Reporting End Date]<br />
<br />
End of Report Period is: IIf([Enter Reporting End Date]&gt;=Format([qrySHOFamil<wbr />ySystemB]!<wbr />[Entry Exit Exit Date],&quot;Short Date&quot;),&quot;Yes&quot;,&quot;No&quot;)
</div>
</div>


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")

Access Date Prompt in Query

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.