Handling 0 record count condition

[Russie]

Hi.

This is a small but annoying problem.

I have a tabular form that extracts data from SQL Server using SQLOLEDB.

My only issue is when the form displays 0 records (i.e. calls a day with no activity) I get '#Error' in my count field.

I'm using count([Amount]) to return the row count. When 0 rows are returned I want the box to display 0 and not #Error.

Thanks for anything.

A star for the answer.

Russie

 

[jioek]

use count(nz([Amount]))
null to 0 function