NULL datatype

[chillay]

If I'm creating a Customer table that includes contact info and I require either a phone number or an email address, how can I ensure that both fields cannot be left blank? In other words, a customer's record can have an entry in the Phone column or in the Email column or in both, but it must have at least one or the other. How do I use the NOT NULL constraint so that either column may be null, but not both in the same record?

Thank you

Chillay

 

[dhookom]

You can view the table properties and set the Validation Rule to:
[tt][blue]Not (IsNull([Phone]) And IsNull())[/blue][/tt]

[COLOR=Blue][B][I]Duane
[url=http://www.access.hookom.net/]Hook'D on Access[/url]
[url=https://mvp.support.microsoft.com/profile/Duane.Hookom]MS Access MVP[/url][/I][/B][/color]

 

[chillay]

Thank you. Sounds good.

Chillay