count error

[dand_dd]

I have a form with a textbox and combobox. The COUNT function give incorrect number of records. I want to show into the textbox the number of products where Prio is null or Prio ="" for all TT(filter is not used) and when i use the filter i want to see the number of records without Prio for the respectively TT.

I have this query, but i don.t know how to implement to function automatic when i start tge form and when i use the combobox filter.

Thanks!

SELECT count(Teilenr)
FROM tblNAP
WHERE TT=tblNAP.Kombinationsfeld37 And (Prio Is Null Or Prio="");

[OBP]

Does the new Query that I have added give you the values that you want?

The Recordset count that your form uses counts the Number of records showing on the form and appears to be working to do that.

[dand_dd]

Yes. Thanks. I have just resolved.