Check Box

[John]

Hello,

I'm using a check box on a form as a parameter within a query:

[Forms]![MyForm]![MyCheckBox]

If the value is -1 (Yes, True, On) the query does not return any records yet
if the value is 0 (No, False, Off) the query returns all records with that
match that value.

Can any one help?

 

[Duane Hookom]

It sounds like you are not actually storing -1 values. Create a totals query
with your particular field and count its occurances.
SELECT [YourField], Count(*) as NumOf
FROM tblYourTable;