S Samuel Shulman Nov 5, 2006 #1 Is there any way to avoide Null values in (like in SQL Server)? Thank you, Samuel
R Rick Brandt Nov 5, 2006 #2 Samuel said: Is there any way to avoide Null values in (like in SQL Server)? Click to expand... If you explain what you mean by "avoid" it might be possible to answer your question. Do you not want to allow Null values in a table? Do you want to build a query that excludes records having a Null? Do you want to build a query that replaces Null with something else?
Samuel said: Is there any way to avoide Null values in (like in SQL Server)? Click to expand... If you explain what you mean by "avoid" it might be possible to answer your question. Do you not want to allow Null values in a table? Do you want to build a query that excludes records having a Null? Do you want to build a query that replaces Null with something else?
A Allen Browne Nov 5, 2006 #3 You you cannot avoid nulls. For a particular field, you can set the Required property to Yes to Nulls are not allowed. You can use Nz() to instruct Access to substitute a value for Null. But you can't avoid them. For more info, and help with working with nulls, see: Nulls: Do I need them? at: http://allenbrowne.com/casu-11.html and: Common errors with Null at: http://allenbrowne.com/casu-12.html
You you cannot avoid nulls. For a particular field, you can set the Required property to Yes to Nulls are not allowed. You can use Nz() to instruct Access to substitute a value for Null. But you can't avoid them. For more info, and help with working with nulls, see: Nulls: Do I need them? at: http://allenbrowne.com/casu-11.html and: Common errors with Null at: http://allenbrowne.com/casu-12.html
