I have a formula set up that basically says:
If COUNT(MyRecordsetName.Value) = 0 THEN
0
ELSE
(MyRecordsetName.Value)
This doesn't seem to be working. When the recordset does not return a recordset, I would like to have 0 displayed on the report, but when a recorset is returned I would like to display a value from that recordset. Any ideas?
Thanks in advance!
If COUNT(MyRecordsetName.Value) = 0 THEN
0
ELSE
(MyRecordsetName.Value)
This doesn't seem to be working. When the recordset does not return a recordset, I would like to have 0 displayed on the report, but when a recorset is returned I would like to display a value from that recordset. Any ideas?
Thanks in advance!