Export to excel...then change the data

[gkaste]

I have a query in access that I wrote a macro to export to excel. This is to make a log file for all my entries (in excel I can make it look much nicer than in an access report). In my form I have several checkboxes, and when data is exported to excel, they show up as TRUE and FALSE. Either before or after the data is exported, can I change these to something like an 'X' or blank (for TRUE or FALSE respectivly).


Thanks
Garrett.

 

[Pat Hartman]

You can change the value in the query:

Select IIf(SomeField = -1, "X", "") As NewField, ....

 

[gkaste]

Ah..I see, that would work. What is the select though? And where do I put this in the query, I dont see. Thanks, and sorry I seem to be missing out on some of the basics here.

 

[gkaste]

Nevermind...I figured it out. Thanks for your help!