I have boolean fields in my database. When i export the data in those fields, I get values of either 'True' of 'False' depending on whether the boxes were ticked or not. I, however, want the exported data to either be 'True' if the box is ticked or blank if not ticked. My only other option is to change the field type which is going to affect the data that have already been inputted in the database. Is it possible to make the fields that have not been ticked to come out as empty when I export their data? If yes, how?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/5/16, 4:34 AM|
|Seen: 158 times|
|Last updated: 5/5/16, 5:04 AM|