Query result = 0 matches. I want this number in my form!

[Patience]

Hi,



I have a query wich sometimes returns zero results. However, I want the query to return the digit 0. Since it does not, my form turns blank because there were no matches. How can I fix this?

I can get it to work with dates. Here the query returns the digit 0 and my form does not go blank.

Thank you very much in advance!

[TheShabz]

shot in the dark but...

have the textbox displaying the 0 be set to:
SELECT Count (myTable.myField)
FROM myTable
WHERE myField = (insert your original SQL here)

let me know if that works.