J
Jcraig713
I am new to using access but am trying to use expressions to make data entry
into my table easier. I want to make it so when a user types in a building
number, the building name and phone number is automatically entered for them.
I have written very few (easy) expressions such as trimming name etc but
this is beyond my expertise. Can someone help? I sure hope so. Not knowing
how to write the expressions is my biggest problem as I try and learn...
This is what I want to accomplish:
If EntityNumber = 01, then entity name = xxx and phone number = xxx
if the answer = no, then check if EntityNumber = 02 then Entity name = xxx
and phone number = xxx
I have 19 entity numbers to go through in this manner. Can someone help?
please advise.... Thanks in advance if so...
)
into my table easier. I want to make it so when a user types in a building
number, the building name and phone number is automatically entered for them.
I have written very few (easy) expressions such as trimming name etc but
this is beyond my expertise. Can someone help? I sure hope so. Not knowing
how to write the expressions is my biggest problem as I try and learn...
This is what I want to accomplish:
If EntityNumber = 01, then entity name = xxx and phone number = xxx
if the answer = no, then check if EntityNumber = 02 then Entity name = xxx
and phone number = xxx
I have 19 entity numbers to go through in this manner. Can someone help?
please advise.... Thanks in advance if so...
)