Convert bit feld to Yes/No

[Ron Hinds]

SQL2K backend Access 97 MDB frontend. I have a ComboBox whose Recordsource
is a SQL Passthrough Query. One of the returned fields is a Boolean value -
bit field in SQL Server. But I want it to display in the Access combo box as
either Yes or No. Currently Access displays 0 or -1. Fine for me, but my end
users don't understand it. Any ideas?

 

[Trey Walpole]

don't know Access, but can't you bind the combobox to the value but display
Yes/No?
that's what comboboxes are for, right <s>

 

[J. M. De Moor]

SELECT
col1, ...
CASE bit_col WHEN 1 THEN 'Yes' ELSE 'No' END AS yn_col
FROM ...;

I'll let Celko maul you with the evils of a Bit datatype... <g>

 

[Ron Hinds]

SELECT
col1, ...
CASE bit_col WHEN 1 THEN 'Yes' ELSE 'No' END AS yn_col
FROM ...;

Genuis - it worked! Thank you!

I'll let Celko maul you with the evils of a Bit datatype... <g>

Can't wait...

 

[Ron Hinds]

don't know Access, but can't you bind the combobox to the value but display
Yes/No?
that's what comboboxes are for, right <s>

Well I know how to do that when I'm returning only one column - but in this
case I am returning multiple columns for display and I wasn't sure how to do
it for just one of the columns... But the other poster's suggestion did the
trick so I'm not going to worry about it. ;-)