I have setup a count query and only want it to count a number if it is not a 0.The count query seems to still count 0's.

How do i set the criteria so that 0's don't get counted?

Is the field you are testing a number or a text field?

You need a where clause

where fldname <>0
If using the Query design grid drag the field into it a 2nd time change the default GroupBy to a where , from the dropdown and put <>0 in the criteria

Brian