Numerical Issues

[kwooten]

I know this is probably a query issue and i can solve it with an NZ Function but im not sure how. Should I do my calcs in the report or the query? Also, how do I do NZ functions? I have a query that is counting E#'s but also have null values. Query 1 does a total count on E# and this query is linked in another query, for reporting as I have 4 other queries linked.

[RuralGuy]

Did you mark this thread as Solved in error? If not, do you care to share your solution with others that read these forums?

[kwooten]

it was nz([field],"0")

[RuralGuy]

Thanks for sharing.