SUM QUERY

  • Thread starter Thread starter Felipe Taylor
  • Start date Start date
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?
 
Use the Nz() function on each component of the sum.

Check Access Help on the Nz() function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Aggregate Function Error 0
Running Sum Query 1
List of values summing to a known value 3
Sum Query With Parameters 5
Sum IIf Statement Values on form 1
Query Sum Amount To Table Field 1

Back
Top