 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2007Format Yes/No in Union
Hi Groupies I have a union query that combines 2 yes/no fields. When I run the query, I get -1 and 0 instead of Yes and No. How can I force the formatting to Yes and No?  SignatureThanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! >Hi Groupies > >I have a union query that combines 2 yes/no fields. When I run the query, I >get -1 and 0 instead of Yes and No. >How can I force the formatting to Yes and No? By displaying the results of the Union query on a Form or Report, with the formatting of the textbox set appropriately. Query datasheets are of *very* limited utility and should not be used for data presentation. John W. Vinson [MVP] >>Hi Groupies >> [quoted text clipped - 11 lines] > > John W. Vinson [MVP] Hi John I have the results showing up in a combo box and I was hoping to have that column read yes/no instead of -1/0. Is there no way to change it for the combo? I do have an alternative but this would be my preferred method. SignatureThanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! >I have the results showing up in a combo box and I was hoping to have that >column read yes/no instead of -1/0. Is there no way to change it for the >combo? I do have an alternative but this would be my preferred method. One thing you could try is to set the Format property of the query field to Yes/No. Or, you could use a calculated field in the query: ShowYesNo: IIf([yesnofield], "Yes", "No") and display that in the combo rather than the raw yes/no field. John W. Vinson [MVP] >>I have the results showing up in a combo box and I was hoping to have that >>column read yes/no instead of -1/0. Is there no way to change it for the [quoted text clipped - 9 lines] > > John W. Vinson [MVP] Setting the Format Property does not work, thus my posting. I will give the calculation a try otherwise I will use my alternative. Thanks John! SignatureThanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.