Chat with a LIVE Microsoft Access Expert!
 
       
 

         

   

Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
 
Chat with a LIVE Microsoft Access Expert!
Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 08-06-2007, 07:48 PM
jphansen jphansen is offline
Registered User
 
Join Date: Aug 2007
Location: Hauppauge, NY
Posts: 3
jphansen is on a distinguished road
Missing field after upsizing

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.
Reply With Quote
Sponsored Links
  #2  
Old 08-07-2007, 02:43 AM
Guus2005's Avatar
Guus2005 Guus2005 is offline
Clueless...
 
Join Date: Jun 2007
Location: The Netherlands
Posts: 1,616
Guus2005 will become famous soon enough
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)
Reply With Quote
  #3  
Old 08-07-2007, 05:14 AM
jphansen jphansen is offline
Registered User
 
Join Date: Aug 2007
Location: Hauppauge, NY
Posts: 3
jphansen is on a distinguished road
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.
Reply With Quote
  #4  
Old 08-07-2007, 05:27 AM
Guus2005's Avatar
Guus2005 Guus2005 is offline
Clueless...
 
Join Date: Jun 2007
Location: The Netherlands
Posts: 1,616
Guus2005 will become famous soon enough
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.
Reply With Quote
  #5  
Old 08-07-2007, 05:01 PM
jphansen jphansen is offline
Registered User
 
Join Date: Aug 2007
Location: Hauppauge, NY
Posts: 3
jphansen is on a distinguished road
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!
Reply With Quote
Sponsored Links
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Field if Another Field is Null andysgirl8800 Forms 4 08-10-2006 07:55 AM
Variable input, field sometimes present, sometimes doesn't exist KyleB Queries 0 06-14-2006 05:58 AM
data missing in 1 field only richrich General 1 04-12-2006 11:39 AM
Calculated Field (Sum) in Form tbaxter Forms 3 06-15-2004 07:37 AM
Date missing in table field arosengrant Tables 0 04-11-2003 08:59 AM


All times are GMT -8. The time now is 09:54 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
(c) copyright 2009 Access World