<div>
It would be easier to do this in the report's RecordSource query. &nbsp;But we don't know what the result is supposed to be when the CtrlCode does not end with &quot;x&quot;<br />
<br />
Select fld1, fld2, fld3, Iif(Right(CtrulCode, 1) = &quot;X&quot;, AccessTotalsSumOfWeight, somethingelse) As Total_X from yourtable;<br />
<br />
Then you can bind Total_X to the report control.
</div>


It would be easier to do this in the report's RecordSource query.  But we don't know what the result is supposed to be when the CtrlCode does not end with "x"

Select fld1, fld2, fld3, Iif(Right(CtrulCode, 1) = "X", AccessTotalsSumOfWeight, somethingelse) As Total_X from yourtable;

Then you can bind Total_X to the report control.

Jeannie Cote

<div>
Thank you both for your help !
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a report on which there is a control called CtrlCode, if the information in this control ends with an X, I need the information already in control AccessTotalsSumOfWeight to be copied in control Total_X<br />
I tried the following formula:<br />
= IIF([CtrlCode] Like &quot;*X&quot;,&quot;[AccessTotalsSumOfWe<wbr />ight]&quot; <br />
I get a mismatch<br />
<br />
Any help would be greatly appreciated<br />
Thanks<br />
Jeannie
</div>
</div>


Hi,
I have a report on which there is a control called CtrlCode, if the information in this control ends with an X, I need the information already in control AccessTotalsSumOfWeight to be copied in control Total_X
I tried the following formula:
= IIF([CtrlCode] Like "*X","[AccessTotalsSumOfWeight]" 
I get a mismatch

Any help would be greatly appreciated
Thanks
Jeannie

IFF expression for an Access report

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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

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.