assigning zero value to null in a form

[Kelvin]

Please Help

I have a Query which searches a table using an autoid. this query returns a count and a sum of two fields returned by the query.

the problem lies when the query returns no matches of the search. when this happens i wish to assign the sum a zero value, but i am having trouble doing so. i have tried "isnull" and a few other "null" commands.

Thanking you
Kelvin Johnston

 

[PaulF]

look into using the NZ function, it should do what you want



PaulF