QBF ( Query by Form) using yes/co datatypegreenspun.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 (email@example.com), April 07, 2003