<div>
Thanks but this doesn't work :(
</div>


<div>
please post the whole SQL statement for the query, thanks ~
</div>


<div>
Just found the problem, my sorry :( sorry
</div>


<div>
glad you got it! ... in explaining to others, one often finds the answer themself ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I'm trying to return a value of 1 if Place is greater than 1 and SPfavcode is not equal to F.<br />
<br />
FR: IIf([Place]&gt;1 And [SPfavcode]&lt;&gt;&quot;F&quot;,1,0) - I've created this but it doesn't work.<br />
<br />
Can anyone help?
</div>
</div>


Hi

I'm trying to return a value of 1 if Place is greater than 1 and SPfavcode is not equal to F.

FR: IIf([Place]>1 And [SPfavcode]<>"F",1,0) - I've created this but it doesn't work.

Can anyone help?

IIf query

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.