Set blank field to zero

[MDDDS]

I have a table that I compare to a query. The Query lists all the states we have business. The table has the state where a client is located and the number of members in the group if it is a group business or individual member if it is an individ. member. I have a second query that totals the # of members in the group for the state(sum), the number of individual members and counts the number of groups in the state for the group business and individ. business. . If there is no business in the state for an ind. but there is group business, the count returns 0 and the sum returns a blank or null(?) value. When I total the amounts in the query, the states with a blank don't add properly-I get a blank value. Can a blank sum be set to zero so when i total values in the query, I get the correct value?

 

[sfreeman@co.mer]

Check the Access Help file for Nz function.