Question About "Reconverting" Data Types

[mrDrive]

Hi,

I'm linking to a SQL Server view to generate a report in Access. In my view, I'm selecting a bit field that has some null values. When I select the bit field, I convert it to CHAR() so that any null values show as empty strings in Access:

select ISNULL(CONVERT(char(20),bit_field1),'') AS converted_bit_field
from MyTable

In my report, I want this value to display as a Yes/No value not a 1 or 0.

My question is whether or not there's a way convert converted_bit_field back to the Yes/No data type?

Thanks for any help!

 

[HitechUser]

mrDrive,

Please have a look at the iif function.

This should do the trick..

 

[mrDrive]

Cool thanx! Never used that function before.