Greetings!
I have a form where I'm trying to display the count of records. Originally, the Control Source for the field that displays the count had the simple
code but apparently it is counting fields containing an empty string. This field may have either a null value or empty string (but I'd rather not go into that).
If tried both of these with no luck:
Any ideas?
I have a form where I'm trying to display the count of records. Originally, the Control Source for the field that displays the count had the simple
Code:
=Count([fieldName])
If tried both of these with no luck:
Code:
=Count(IIf([fieldName]>0, [fieldName], 0))
Code:
=Count(IIf(([fieldName]>0) And ([fieldName] Is Not Null), [fieldName], 0))