output checkbox to a text file

  • Thread starter Thread starter BruceS
  • Start date Start date
B

BruceS

I am trying to export data from a report to a text file for importation into
another database. Everything shows in the text file except the checkboxes.
Is there anyway to get the X or the -1/0 to show in the text file?
 
Use an iif statement in the query to convert first:
IIF([yourfield] = -1, "yes", "no")
That would make your -1 into a yes and zero into a no.
 
Back
Top