Check box result in query

[Gemma Khan]

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]

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)