oli82
10-01-2008, 12:43 AM
Morning,
I have a form in Access 2007 that uses tick boxes, this is looking through ODBC connection to SQL server 2005 bit fields.
This works ok until I want to filter by form when I do so the filter puts the criteria as -1 whereas it will only work if true or false is input in the criteria. Is there a way around this, should I change the field type to boolean in SQL.
Many thanks your responses are really appreciated,
Oliver
I have a form in Access 2007 that uses tick boxes, this is looking through ODBC connection to SQL server 2005 bit fields.
This works ok until I want to filter by form when I do so the filter puts the criteria as -1 whereas it will only work if true or false is input in the criteria. Is there a way around this, should I change the field type to boolean in SQL.
Many thanks your responses are really appreciated,
Oliver