export text file

[Pat Coleman]

have a True/False field in a query that we want to export to a text file but
when we do the true/false comes out as 1/0

Is there any way I can get the report to export out the words
"True" or "False"

Thanks

 

[John Vinson]

have a True/False field in a query that we want to export to a text file but
when we do the true/false comes out as 1/0

Is there any way I can get the report to export out the words
"True" or "False"

Thanks

Use a calculated field in your query:

ExpTrueFalse: Iif([fieldname], "True", "False")

John W. Vinson[MVP]

 

[Pat Coleman]

Thanks !

have a True/False field in a query that we want to export to a text file
but
when we do the true/false comes out as 1/0

Is there any way I can get the report to export out the words
"True" or "False"

Thanks

Use a calculated field in your query:

ExpTrueFalse: Iif([fieldname], "True", "False")

John W. Vinson[MVP]