QUERY A YES/NO FEILD

[meltingpot]

Having Problems with the following query..


SELECT addressbook.InputWebb, addressbook.Q_67SKIP
FROM addressbook
WHERE (((addressbook.InputWebb)=True) AND ((addressbook.Q_67SKIP)=True));

The feilds - InputWebb and Q_67SKIP are yes/no checkboxs in the true/false format.
It returns nothing but I can see in the database that these feilds are used, some are ticked as 'True'

Help ?

 

[HarleyQuinn]

If you're table's set up as you say and there are records with both InputWebb and Q_67SKIP set to TRUE I can see no reason why you're not getting any records returned.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[meltingpot]

yep your right .. but never the less. I have checked the table with the fields in and they do infact contain checkboxs that are 'True' ????

 

[meltingpot]

just rebboted and the problem has dissappeared .. we love computers. Thanks for your help !