Math, Adding two fields in a report

aerosmith

Registered User.
Local time
Today, 00:14
Joined
Jan 12, 2009
Messages
26
Good Morning,
Im trying to do a calculation on a report, im using two fieldnames from controls, as follows

=[txtother]+[txtinvalid]

The thing is it calculates it sometimes, but does skips it as well. i have attached a picture of what i see
 

Attachments

  • test3.JPG
    test3.JPG
    31.7 KB · Views: 117
Do the txtother and txtinvalid fields both contain data?

I don't really get what the attached is demonstrating either
 
Try looking up the NVL function to replace NULL values.

A number field (IMHO) should always have a default value of 0 and would never be Null.
 
They both contain values but not all the time. txtother has maybe 4 entries with numbers across the report.



what i want is txtother to be added to the txtinvalid field
 
the picture shows figures in invalid but they dont showup in the txtbox i created with the formula to add both fields
 
like the first circle shows 81.20 but the space is empty where the formula, i wanted it to show the 81.20 because there was nothing in txtother for that one entry.
 
Try looking up the NVL function to replace NULL values.

A number field (IMHO) should always have a default value of 0 and would never be Null.

Just making sure you catch my post??
 
Sorry Yes i did :) i used the nz function is that similar?
 
*ugh* Oracle on the brain, sorry...

Yes NZ in Access :(
 
I might have fixed it, There was a problem with a table, and my query :) i guess i have to hit the books harder and see where i messed up
 
NZ should have resolved your problem?

That is ... if your problem is the null value...
 

Users who are viewing this thread

Back
Top Bottom