 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Giving a value to a null field
I have a query that has null values in the criteria field. What is the correct expression to fill that field with the same value for all the records in that result set? To replace a Null with another value you can use the NZ Function Nz([FieldName],0) will retun 0 instead of Null Nz([FieldName],1) will retun 1 instead of Null  SignatureGood Luck BS"D > I have a query that has null values in the criteria field. What is the > correct expression to fill that field with the same value for all the records > in that result set? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.