Change Not Nulls to Text Strings

  • Thread starter Thread starter mikebaldam
  • Start date Start date
M

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
 
Combined: Iif([Option1], "Option1", "") & Iif([Option2], "Option2", "")

--
HTH
Van T. Dinh
MVP (Access)



mikebaldam said:
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
Click to expand...
 
Back
Top