export to xls.

[Humbled Learner]

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?

 

[Jerry Whittle]

TheError: IIf([error] = 0, "No", "Yes")

 

[Humbled Learner]

Thank You,,, where would I paste that information?
IIf([error] = 0, "No", "Yes")

TheError: IIf([error] = 0, "No", "Yes")
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

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?

 

[PieterLinden via AccessMonster.com]

Thank You,,, where would I paste that information?
IIf([error] = 0, "No", "Yes")

TheError: IIf([error] = 0, "No", "Yes")

[quoted text clipped - 7 lines]

In the next available column in the QBE grid.