I have a form which contains a checkbox along with some other Yes/No Controls. The form updates a table.
When I run queries on the table, the value shown for the checkbox is always either -1 or 0 - now I understand that is correct, but is there any way to display that as yes or no in in the actual datasheet view of the query - reason is - I don't do much more with the datasheet - it is just exported to an excel spreadsheet, for other people to use.
Any help greatly appreciated !
When I run queries on the table, the value shown for the checkbox is always either -1 or 0 - now I understand that is correct, but is there any way to display that as yes or no in in the actual datasheet view of the query - reason is - I don't do much more with the datasheet - it is just exported to an excel spreadsheet, for other people to use.
Any help greatly appreciated !