I am now finishing up an application that I had a question about last week and have three main questions that I will post as separate questions. Here is the first.
OK, I know I could just leave the period after the initial in my table and be done with this one, but I think there has to be a more artful way to manage it.
I am storing names in four distinct fields - first, mi, last, suffix. When generating reports with the complete name, I want to be able to insert a period and a space (". ") after the middle initial. The only reason it is complex is because only about 55% of my records have middle initials, so it needs to be conditional.
Any suggestions would be greatl appreciated.