Things have been working well with my charitable donations database--until I discovered a problem with a calculated field "Greeting" [Title] & (" "+[Last Name]).
The "Title" field has Mr., Mrs, Mr & Mrs, Ms., Miss, Rev., Rev. Mr., etc. to choose from. There's also a field "Address as" (don't know what's up but I can't paste it here as I did with the above).
Address As give me the address label "Mr. and Mrs. William Smith". "Greeting" gives me "Dear Mr. and Mrs. Smith."
Here's the problem: Catholic priests are formally addressed as "Rev. John Smith" but the letter greeting would be "Dear Father Smith." So the question is: is there a way to make an exception to the calculated field so that when the Title is "Rev" the greeting will be "Fr." (or "Father")?
Oh yeah--and there's another one: Deacons are "Rev. Mr" but would be greeted as "Dear Deacon Jones,".
Thanks!
LATER EDIT: I haven't used this database in quite a while so I only just discovered how I worked around this: instead of doing a letter "Dear Father Smith", I designed statements that simply give the name and address (Rev. John Smith)--so basically I'm not using the "Greeting field" at all. I'd still be curious to know if there IS a way around this.
The "Title" field has Mr., Mrs, Mr & Mrs, Ms., Miss, Rev., Rev. Mr., etc. to choose from. There's also a field "Address as" (don't know what's up but I can't paste it here as I did with the above).
Address As give me the address label "Mr. and Mrs. William Smith". "Greeting" gives me "Dear Mr. and Mrs. Smith."
Here's the problem: Catholic priests are formally addressed as "Rev. John Smith" but the letter greeting would be "Dear Father Smith." So the question is: is there a way to make an exception to the calculated field so that when the Title is "Rev" the greeting will be "Fr." (or "Father")?
Oh yeah--and there's another one: Deacons are "Rev. Mr" but would be greeted as "Dear Deacon Jones,".
Thanks!
LATER EDIT: I haven't used this database in quite a while so I only just discovered how I worked around this: instead of doing a letter "Dear Father Smith", I designed statements that simply give the name and address (Rev. John Smith)--so basically I'm not using the "Greeting field" at all. I'd still be curious to know if there IS a way around this.
Last edited:
