Row Source Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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];
 
Awesome! Thanks!

KARL DEWEY said:
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


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