export to xls.

  • Thread starter Humbled Learner
  • Start date
H

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

Humbled Learner

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

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


Humbled Learner said:
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?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Statement in Query 2
export 1 query 5 times to 1 excel file 7
export 1 query multiple times to 1 excel file 1
Query works-Export fails "...you and another user are attempting to change the same data..." 5
Export query with passed criteria 6
Including the Current Date in the File Import / Export Title 3
Query to text file cuts my leading zeros off. 4
Make Table Query with path Parameter 1

Top