QBF ( Query by Form) using yes/co datatype

greenspun.com : LUSENET : DBAzine : One Thread

I have a tbl with many yes/no datatypes. I want to create a QBF that will allow the user to click on any box and perform a query.

The tables are in SQL 2000 with Access as the front end. I changed the datatype in sql from bit to int to allow for the storage of -1 which access does in this datatype. I can do a search by form using access built in functionality however the option to a actual query is not working.

Pleas Help as I'm trying to see if there is a way to do this without having to think every possible combination of strings there could be1

-- Janee Davis (jdavis@cmht.com), April 07, 2003


Moderation questions? read the FAQ