|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 2nd, 2010, 06:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
export to xls.
Good Afternoon,
I have a query set to export to xls... table = "error" set to yes/no Form reflects a check box Query has "error" and shows check box (checked or unchecked) When I export query to xls, it reports true/false. Can I make it export Yes/No? -- Thank You 
|
|
#2
March 2nd, 2010, 07:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
export to xls.
TheError: IIf([error] = 0, "No", "Yes")
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Humbled Learner" wrote: Good Afternoon, I have a query set to export to xls... table = "error" set to yes/no Form reflects a check box Query has "error" and shows check box (checked or unchecked) When I export query to xls, it reports true/false. Can I make it export Yes/No? -- Thank You
|
|
#3
March 2nd, 2010, 09:03 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
export to xls.
Thank You,,, where would I paste that information?
IIf([error] = 0, "No", "Yes") "Jerry Whittle" wrote: TheError: IIf([error] = 0, "No", "Yes") -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Humbled Learner" wrote: Good Afternoon, I have a query set to export to xls... table = "error" set to yes/no Form reflects a check box Query has "error" and shows check box (checked or unchecked) When I export query to xls, it reports true/false. Can I make it export Yes/No? -- Thank You
|
|
#4
March 2nd, 2010, 09:43 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
export to xls.
Humbled Learner wrote:
Thank You,,, where would I paste that information? IIf([error] = 0, "No", "Yes") TheError: IIf([error] = 0, "No", "Yes") [quoted text clipped - 7 lines] When I export query to xls, it reports true/false. Can I make it export Yes/No? In the next available column in the QBE grid. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201003/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
