Missing field after upsizing

[jphansen]

I recently upsized a database to SQL Server that had been working as a native Access database for years. After upsizing, a number of calculated fields (unbound) are not showing results. Basically, the fields in question calculate a total based on the values in a few other fields. I've upsized before and have never run into a problem like this.

[Guus2005]

You are using calculated (unbound) fields, which means that you have to fill the controls yourself?
If that is the case, make sure that the calculation is still correct(ly working)

[jphansen]

The calculations haven't changed at all. I simply changed the underlying data source from Jet to SQL Server. It's a strange problem. To test things, I created a new (much simpler) form using the same data source and same calculation and it worked! I'm baffled.

[Guus2005]

Ok, your calculations don't work. check your input for the calculations.
If one of the calculations is A * (B + C) and C = Null then the complete formula is Null. So check your input.

If your still "baffled" (whatever that may be) try posting your database and i'll have a look.

[jphansen]

Thank you very much...you hit on it. Apparently, the SQL Server database presents nulls differently than Jet (still researching that). As a result, the equation evaluates to null which causes the blank fields. As a temporary fix, I used nz(A,0) + nz(B,0) +nz(C,0) and it works. I'm going to see if there is a way for SQL Server to present nulls differently.

Thanks again!