A aerosmith Registered User. Local time Today, 00:14 Joined Jan 12, 2009 Messages 26 Jan 16, 2009 #1 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 31.7 KB · Views: 117
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
P Peter Reid Registered User. Local time Today, 08:14 Joined Dec 3, 2003 Messages 134 Jan 16, 2009 #2 Do the txtother and txtinvalid fields both contain data? I don't really get what the attached is demonstrating either
Do the txtother and txtinvalid fields both contain data? I don't really get what the attached is demonstrating either
N namliam The Mailman - AWF VIP Local time Today, 09:14 Joined Aug 11, 2003 Messages 11,695 Jan 16, 2009 #3 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.
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.
A aerosmith Registered User. Local time Today, 00:14 Joined Jan 12, 2009 Messages 26 Jan 16, 2009 #4 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
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
A aerosmith Registered User. Local time Today, 00:14 Joined Jan 12, 2009 Messages 26 Jan 16, 2009 #5 the picture shows figures in invalid but they dont showup in the txtbox i created with the formula to add both fields
the picture shows figures in invalid but they dont showup in the txtbox i created with the formula to add both fields
A aerosmith Registered User. Local time Today, 00:14 Joined Jan 12, 2009 Messages 26 Jan 16, 2009 #6 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.
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.
N namliam The Mailman - AWF VIP Local time Today, 09:14 Joined Aug 11, 2003 Messages 11,695 Jan 16, 2009 #7 namliam said: 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. Click to expand... Just making sure you catch my post??
namliam said: 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. Click to expand... Just making sure you catch my post??
A aerosmith Registered User. Local time Today, 00:14 Joined Jan 12, 2009 Messages 26 Jan 16, 2009 #8 Sorry Yes i did i used the nz function is that similar?
N namliam The Mailman - AWF VIP Local time Today, 09:14 Joined Aug 11, 2003 Messages 11,695 Jan 16, 2009 #9 *ugh* Oracle on the brain, sorry... Yes NZ in Access
A aerosmith Registered User. Local time Today, 00:14 Joined Jan 12, 2009 Messages 26 Jan 16, 2009 #10 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
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
N namliam The Mailman - AWF VIP Local time Today, 09:14 Joined Aug 11, 2003 Messages 11,695 Jan 16, 2009 #11 NZ should have resolved your problem? That is ... if your problem is the null value...