nullToZero function

[Graham]

Database 1 contains a report which uses a nullToZero
function to fill any 'gaps' in the report with a zero
e.g. datasource of field is =nulltoZero([Field A]).

The report is copied to Database 2 for use there; all the
necessary supporting queries and tables are present.

The report does not run but gives an error. On my PC it
treats the function call as a parameter and asks me for a
value. Open Database 2 on a colleagues PC and it says it
can't find msowcf.dll (which a web component library!).

Why the difference in behaviour, and please, how do I get
database 2 to accept the nulltozero function as a function?

Thanks.
Graham.

 

[Duane Hookom]

NullToZero() is not a function in Access. You would need to copy the code
with the function to database 2. Otherwise, you could probably replace
NullToZero() with Nz().