Is there any way to avoide Null values in (like in SQL Server)?


Thank you,
Samuel

Samuel Shulman wrote:
> Is there any way to avoide Null values in (like in SQL Server)?

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?


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Samuel Shulman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Is there any way to avoide Null values in (like in SQL Server)?
>
>
> Thank you,
> Samuel