View Full Version : Check box result in query


Gemma Khan
11-10-2009, 07:46 PM
Hi,
I am making of inventory system, am facing some problem in query designing.
I made one check box on the Form.
If user check the box then record will save otherwise not.
My problem is How to set the criteria so that the Query will look at only the checkbox items from the table before printing.
Any help

Galaxiom
11-10-2009, 08:05 PM
WHERE [CheckboxFieldName] will do it.

Because it is a boolean field this is the same as:
[CheckboxFieldName]= True

(though Access seems to prefer to represent it as <> False)