I am trying to design a letter report to be sent to a patient as a reminder in case they miss their appointment for review. I managed to write ="Dear " & [PtName] & "," in the Dear section of the letter. My challenge is: I want to pick only the first name in the PtName field and i want it to be in proper case. In your Excel classes, i leanrt that if say i had Richard Rost in cell A1, i would use a formula like =PROPER(LEFT(A1, SEARCH(" ",A1,1))) to peel off Richard. Where can i place a similar function in Access (using StrConv in this case as demonstrated at 10:40 of this video)in order to get the first name only? My guess is that it should be possible in Ms Access.
My question is rather long. I hope you will understand me
MICAH
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 222.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.