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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|