How To add Words

[aamer]

I am using the following statement in a query

XREM: IIf([Rstatus]=Null,[Rstatus],[Remarks] & " " & [Customers Bank])

The Result I get is:

Without Poly Sheet Unsorted Citi Bank

Without Poly Sheet Unsorted This Is Remarks
Bank: Citi Bank This is Bank Name





How can I get the result as

Without Poly Sheet Unsorted Bank: Citi Bank

If the bank is not added in the data
the result should look as follows

Without Poly Sheet Unsorted


Not As
Without Poly Sheet Unsorted Bank:

[orange]

Try (to handle NULL)

iif(IsNull([Rstatus]),[Rstatus],[Remarks] & " " & [Customers Bank])

I'm not sure what is in your record for sure, but you could try this also

iif(IsNull([Rstatus]),[Rstatus],[Remarks] & " Bank: " & [Customers Bank])

[aamer]

Tried both in query

XREM: iif(IsNull([Rstatus]),[Rstatus],[Remarks] & " " & [Customers Bank])

AND

XREM: iif(IsNull([Rstatus]),[Rstatus],[Remarks] & " Bank: " & [Customers Bank])



The result is BLANK / NULL

[orange]

Yes, your test seems backwards

Try
iif(IsNull([Rstatus]),[Remarks] & " " & [Customers Bank],[Rstatus])

I'm not sure what is in your record for sure, but you could try this also

iif(IsNull([Rstatus]),[Remarks] & " Bank: " & [Customers Bank],[Rstatus])

[aamer]

XREM: IIf(IsNull([Rstatus]),[Remarks] & " Bank: " & [Customers Bank],[Rstatus])

This works fine if the CUSTOMER BANK is mention / selected in the data but if it is blank or null then the data looks as follows:

Without Poly Sheet Unsorted Bank:

where as What I want is if the CUSTOMER BANK is blank / null it should omit BANK: as the bank is already not there. BANK: should only show if the bank name is selected

[orange]

Show us some of the values in Rstatus --- is it Null, "" zero length string or space?
How is the field defined -? string/text, number or variant

and use this

iif(IsNull([Rstatus]),[Remarks] & " " & [Customers Bank],[Rstatus])

[aamer]

The Value of Rstatus ---- is NULL

It is a TEXT field

[orange]

Show us a few of the records with RStatus.
Do you mean text field with a value "NULL"???


See this and NULL