Totals not displaying on my report.

[kjspear]

Hello everyone:

I have a question about adding totals from two different queries. I created two text boxes one for the Grand total:

=Sum("[PAID]")+DSum("[paid]","noshow query","[PAID]")

and one for the other query:

=DSum("[paid]","noshow query","[PAID]")

Okay, if there is an amount in the 'noshow query', lets say $25.00, then it is calculated in the Grand total text box. However, if there is no dollar amount in the noshow query', that text field remains blank. This would normally not be an issue, but the Grand total is blank also. The grand total is also calculating the totals for the underlying query in the report.
In other words the Grand total text field calculates the total from the underlying query and also includes the totals from the 'noshow query'. If there are no figures to include in the 'noshow query', then the report such simply show the sum from the underlying table.

Does any one know why the totals are not being displayed when the second query has no totals?

Any assistance will be appreciated. I'm sure it's something minor that if have overlooked.

KJ

 

[jebry]

Hi KJ!

Try this:

=Sum("[PAID]")+Nz(DSum("[paid]","noshow query","[PAID]"),0)

hth


Jeff Bridgham
bridgham@purdue.edu