export text file

  • Thread starter Thread starter Pat Coleman
  • Start date Start date
P

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
 
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
Click to expand...

Use a calculated field in your query:

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

John W. Vinson[MVP]
 
Thanks !

John Vinson said:
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
Click to expand...

Use a calculated field in your query:

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

John W. Vinson[MVP]
Click to expand...
 
Back
Top