Some fields in an Access report (tick-boxes) are not exported from Access 2003 to Excel 2003 when I use the export wizard in Access. I would rather that they are included. I don't really care how the data is presented. It could be by setting the Excel cell contents to TRUE if the box is ticked, FALSE if unticked. Or it could be assigned a numerical value 1 for ticked, 0 for unticked. Or pretty much any other binary combination.
Is there a way to achieve this?
Thanks