Reports: Feilds vs Expressions

[colleenvr]

I have generated a receipt in a report that includes the Fields "TotalDonated" and "Deduction" (listed as field in the Control Source rather then an expression). A Third field is a Calculated field that gives the number I need. TotalDonated-Deduction. No Prob.



I have a problem when there is no data listed in Deduction. In report view it skips over people who do no have the "deduction" field list. How do I get around this?

[June7]

What do you mean by 'skips over' - the calculated field doesn't show anything? The issue is that Deduction is Null. Arithmetic with Null results in Null. Need to handle possible Null.

[TotalDonated]-Nz([Deduction],0)

[colleenvr]

Thanks for the formula. I have inserted and it does not mess up anything so that's good, but I still have the same "Skipping" problem

Every record(name) has a "TotalDonated" associated with it but not every name as a "Deduction". Names that has no deduction but still a TotalDonated do not get produced in the report (they are skipped over). The problem comes when a record does not have a "Deduction" value. Should I be thinking along the lines of IFMissing......

[June7]

I expect the issue is with the query, probably INNER JOIN should be an OUTER (LEFT or RIGHT) JOIN.

Really need to know more about data structure. Post the query SQL statement for analysis. Or provide the db. Follow instructions at bottom of my post.

[colleenvr]

I expect the issue is with the query, probably INNER JOIN should be an OUTER (LEFT or RIGHT) JOIN.

Really need to know more about data structure. Post the query SQL statement for analysis. Or provide the db. Follow instructions at bottom of my post.

___________________

I think in know what i need.... could you provide an expression for the following statements. [Field amount], but if it's blank (meaning no data) then 0?

[June7]

Nz([Field amount],0)