var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Getting Initial letters from text strings
Bit of a problem with the following and not sure how to even start...
I have a form called "frmPatients" whose source is the table "tblPatients" with two fields called "Forename" and "Surname".
I also have a field called "Initials".
How can I populate the "Initials" field with the first letter of the text in "Forename" and then the first letter in the field "Surname"?
I'm not even sure if this should take place in the form level or in a query...
Any help would be greatly appreciated,
this query does it.
UPDATE YourTableName SET Initials = UCase(Left(Trim([forename]),1)+"."+Left(Trim([surname]),1)+".");