This topic is locked

Using Filters to filter a check box

9/14/2009 1:38:09 PM
ASPRunnerPro General questions
C
cordaco author

Can anyone help me with the following. I have an Agents table which I need to filter between active and non active agents. I am using a check box field to enter tru or false. I have tried everything I know on the Edit SQL query page. I keep getting this messages:
Error message:

[Microsoft][ODBC Microsoft Access Drive] Date type mismatch in criteria expression.

P
Philip 9/14/2009

Hi,

have you tried to search for 0 or 1?

Philip

C
cordaco author 9/14/2009

Got it to work...
Thanks