changing information inside of a textbox

[WaltLukeIII]

I have a textbox in a report that currently has two fields from a query as the control source
=[field1] & " and " & [field2]
this works well except that sometimes field1 is empty and sometimes field2 is empty. How can I fix this report so that if both field's are populated then it adds the and.
Thanks

Walt III
SAElukewl@netscape.net

 

[scriverb]

Give this a try. We may have to include empty-string checks also but first give this a try:

=[field1] & IIF(Not IsNull([Field1] and Not IsNull([field2]), " and ", "") & [field2]

Post back with results.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[WaltLukeIII]

Thanks Bob

That worked perfectly I was even able to combine that with another field and eliminate some more redundant fields in a printout.

=[field1] & " " & [field1] & IIf(Not IsNull([Field1]) And Not IsNull([field2])," & ","") & [field2]

Walt III
SAElukewl@netscape.net

 

[scriverb]

Glad that I was able to help you.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]