<div>
try this:<br />
=IIf(DateAdd(&quot;yyyy&quot;,1,[Las<wbr />tApmnt])&lt;D<wbr />ate() And Not IsNull([ContactType]) And ([ContactType]&lt;&gt;&quot;None&quot; Or [ContactType]&lt;&gt;&quot;Trials&quot;),&quot;<wbr />EXPIRED&quot;,&quot;<wbr />&quot;)
</div>


try this:
=IIf(DateAdd("yyyy",1,[LastApmnt])<Date() And Not IsNull([ContactType]) And ([ContactType]<>"None" Or [ContactType]<>"Trials"),"EXPIRED","")

<div>
Sorry PuppyDog, your solution didn't work. &nbsp;Thanks to all for a quick response.
</div>


Sorry PuppyDog, your solution didn't work.  Thanks to all for a quick response.

<div>
<div class="content wysiwyg-content">
If have the following formula in a text box:<br />
<br />
=IIf(DateAdd(&quot;yyyy&quot;,1,[Las<wbr />tApmnt])&lt;D<wbr />ate() And (Not IsNull([ContactType]) And ([ContactType]&lt;&gt;&quot;None&quot; Or [ContactType]&lt;&gt;&quot;Trials&quot;)),<wbr />&quot;EXPIRED&quot;,<wbr />&quot;&quot;)<br />
<br />
I am trying to check if a date from [LastApmnt] is more than a year old and if so put up EXPIRED only when [ContactType] is not null and not equal to None or Trials. &nbsp;<br />
<br />
I can get a formula working &nbsp;when only checking for trials or none but not both. &nbsp;What am I doing wrong?<br />
<br />

</div>
</div>


If have the following formula in a text box:

=IIf(DateAdd("yyyy",1,[LastApmnt])<Date() And (Not IsNull([ContactType]) And ([ContactType]<>"None" Or [ContactType]<>"Trials")),"EXPIRED","")

I am trying to check if a date from [LastApmnt] is more than a year old and if so put up EXPIRED only when [ContactType] is not null and not equal to None or Trials.  

I can get a formula working  when only checking for trials or none but not both.  What am I doing wrong?



Proper syntax for IIF using OR

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.