Hi folks...
Im kind of new to Access... I'm OK with Excel, and could just about get by with Ability database, but I can't see how to do this in Access...
The situation is this;
I have an Address Database. One of the fields is "Title". Another is "PostalTitle" I want "PostalTitle" to contain a formula that says, "If the Title is Mrs, Miss or Ms, leave blank, else same as Title".
Now I think I'm OK with the syntax of how to construct the formula, but I can't see how to make a field actually contain a formula.
Am I being stupid, or can it not be done, (easily!)
Thanks in anticipation,
Rregards,
Simsy
Im kind of new to Access... I'm OK with Excel, and could just about get by with Ability database, but I can't see how to do this in Access...
The situation is this;
I have an Address Database. One of the fields is "Title". Another is "PostalTitle" I want "PostalTitle" to contain a formula that says, "If the Title is Mrs, Miss or Ms, leave blank, else same as Title".
Now I think I'm OK with the syntax of how to construct the formula, but I can't see how to make a field actually contain a formula.
Am I being stupid, or can it not be done, (easily!)
Thanks in anticipation,
Rregards,
Simsy