I am referencing with a MSAccess Query a column in an (SQL) database. This column is of type (bit, not null). From within the Query, how do I convert it to a boolean so that I can compare it to the values True/False. Not too sure but I think the equivalent question is how to convert a data type bit (0/1) to a datatype Boolean (True/False) in MSAccess/VB?
I would avoid trying this for now - stick with your original question. I didn't answer as I've not had this problem for over 4 years and have forgotten the precise issues. Converting to Access Boolean is unlikely to yield much.