Missing Numbers

[kholm]

I am using a query to add two amount together and it seems to be leaving one amout out. Using the date and store number as the link, and in the join properties I use number 2. When is use the statement Other:[sumofotheramt]+[sumofrentalamt], it only returns the rental amount.

Help,

Kristin

 

[HJAMES]

Try:

Other: Nz([sumofotheramt]) + Nz([sumofrentalamt])