Change Not Nulls to Text Strings

[mikebaldam]

I got a query pulling data from some check boxes... I'm trying to create
a concatenated field that inserts a text string (ie Option1 Option2
etc)for each record with a Not Null Value...

So far I've got ...

NewField: Nz([TblA]![Option1]+Nz([TblA]![Option2]))

with Not Null as the criteria... This pulls the data into the NewField
but as -10 or 00 or 0-1 etc...

I want to pull in only the -1's AND change the -1's to text strings
such as Option1 or Option2.

Any Help would be greatfully appreciated...


Mike

 

[Van T. Dinh]

Combined: Iif([Option1], "Option1", "") & Iif([Option2], "Option2", "")

--
HTH
Van T. Dinh
MVP (Access)

I got a query pulling data from some check boxes... I'm trying to create
a concatenated field that inserts a text string (ie Option1 Option2
etc)for each record with a Not Null Value...

So far I've got ...

NewField: Nz([TblA]![Option1]+Nz([TblA]![Option2]))

with Not Null as the criteria... This pulls the data into the NewField
but as -10 or 00 or 0-1 etc...

I want to pull in only the -1's AND change the -1's to text strings
such as Option1 or Option2.

Any Help would be greatfully appreciated...


Mike