SUM QUERY

F

Felipe Taylor

I have a query that sums some values from other queries. When one of the
values from one of the primary queries is null, the sum query returns no
value at all...
Any ideas?
 
V

Van T. Dinh

Use the Nz() function on each component of the sum.

Check Access Help on the Nz() function.
 
Top