<div>
You may wish to be accurate to the minute, and Format can be used:<br />
<br />
Format(DateDiff(&quot;n&quot;,[Date]<wbr />,[Now])\14<wbr />40,&quot;Yes/No<wbr />&quot;)<br />
<br />
/gustav
</div>


You may wish to be accurate to the minute, and Format can be used:

Format(DateDiff("n",[Date],[Now])\1440,"Yes/No")

/gustav

<div>
Thank you, Jim. &nbsp;I was totally over thinking this.
</div>


Thank you, Jim.  I was totally over thinking this.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have two columns, Date &amp;&nbsp;Now. &nbsp;They are both formatted as General Date <br />
<br />
Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOW<br />
10/10/2013 4:11:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10/10/2013 4:59:33 PM<br />
9/5/2013 5:41:00 PM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/10/2013 4:59:33 PM<br />
<br />
I want to be able to query for [NOW] &gt;24 hours from [Date]. &nbsp;A simple &quot;Yes&quot; &quot;No&quot; answer would suffice.<br />
<br />
Any simple solution for an iif expression here?<br />
<br />
Your help is greatly appreciated. &nbsp;I am sure that I must be overthinking this.<br />
<br />
Thank you
</div>
</div>


Hello Experts,

I have two columns, Date & Now.  They are both formatted as General Date 

Date	                                         NOW
10/10/2013 4:11:00 AM	10/10/2013 4:59:33 PM
9/5/2013 5:41:00 PM	                     10/10/2013 4:59:33 PM

I want to be able to query for [NOW] >24 hours from [Date].  A simple "Yes" "No" answer would suffice.

Any simple solution for an iif expression here?

Your help is greatly appreciated.  I am sure that I must be overthinking this.

Thank you

Now is greater than 24 hours of given date

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.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.