I am developing a database which has a yes/no data type field in it.
A sample of the table is below:

Customer Name - text
Customer Still Active - yes/no data type

I need to develop a query which creates 2 seperate tables from the master table which are based on whether a customer is still active or not.
However, i am having problems creating a query in which the main field of query is the yes/no data type. I've had a host of erros - any help in this area would be more than welcome.

thank you

The Yes/No type field is a boolean type. And the True value of booleans in Access is "-1", not "1" as in many other languages.

Need something like:
If StillActive=-1 then append to table1
Else
If StillActive=0 then append to table2
Else
Do Nothing, must be a null value.
======================================
Could do 2 separate MakeTable queries:
1. Select all where StillActive = -1
2. Select all where StillActive = 0

Sanity Check: Total Records in Table1 and Table2 = Total Rercords in original table. Any difference in count = Null values in StillActive.
=======================================

...which is why you should you the intrinsic constants TRUE and FALSE whenever you wish to do tests of this nature.


Brian Skelton
Braxis Computer Services Ltd.

Would like to thank you both for your useful comments, i have now got the query working using your guidelines.

Much appreciated,

Andrew