Row Source Formatting

[Guest]

I have a list box property

SELECT [qBiz Overview Presenters].Preferred, [qBiz Overview Presenters].[CO
Date], [qBiz Overview Presenters].[CO Time], [qBiz Overview Presenters].[CO
Open/Close] FROM [qBiz Overview Presenters] ORDER BY [qBiz Overview
Presenters].[CO Date], [qBiz Overview Presenters].[CO Open/Close];

It brings back the correct data but displays [qBiz Overview
Presenters].Preferred as a 0 or -1 depending on if the field is No or Yes. I
am looking for it to bring back a "Yes" or "No" (or even better a "Y" or a
"N" if not too much trouble). The table where the presenter information is
stored has .Preferred as format Yes/No.

Thanks

 

[Guest]

Try this ---
SELECT IIF([qBiz Overview Presenters].Preferred = -1,"Y","N") AS Preferred_,
[qBiz Overview Presenters].[CO Date], [qBiz Overview Presenters].[CO Time],
[qBiz Overview Presenters].[CO Open/Close] FROM [qBiz Overview Presenters]
ORDER BY [qBiz Overview Presenters].[CO Date], [qBiz Overview Presenters].[CO
Open/Close];

 

[Guest]

Awesome! Thanks!

Try this ---
SELECT IIF([qBiz Overview Presenters].Preferred = -1,"Y","N") AS Preferred_,
[qBiz Overview Presenters].[CO Date], [qBiz Overview Presenters].[CO Time],
[qBiz Overview Presenters].[CO Open/Close] FROM [qBiz Overview Presenters]
ORDER BY [qBiz Overview Presenters].[CO Date], [qBiz Overview Presenters].[CO
Open/Close];

--
KARL DEWEY
Build a little - Test a little

I have a list box property

SELECT [qBiz Overview Presenters].Preferred, [qBiz Overview Presenters].[CO
Date], [qBiz Overview Presenters].[CO Time], [qBiz Overview Presenters].[CO
Open/Close] FROM [qBiz Overview Presenters] ORDER BY [qBiz Overview
Presenters].[CO Date], [qBiz Overview Presenters].[CO Open/Close];

It brings back the correct data but displays [qBiz Overview
Presenters].Preferred as a 0 or -1 depending on if the field is No or Yes. I
am looking for it to bring back a "Yes" or "No" (or even better a "Y" or a
"N" if not too much trouble). The table where the presenter information is
stored has .Preferred as format Yes/No.

Thanks