Forum Discussion
Left function in a calculated column
I'm trying to use the Left function to copy the first character of a column into a new column. In design view I add a new column to the table, and select calculated, which brings up the expression b...
If you want to do it you will need to do it in a query or in a form based on this table.
Example:
InitialsSearch: Left([FirstName],1) & "." & Left([LastName],1) & "."
If you add this as a collumn in a query it works good.
In a form you can connect to the event afterupdate from the column where the information was entered. In my example it looks like:
Private Sub LastName_AfterUpdate()
Me.Initials = Left(Me.FirstName.Value, 1)
End Sub
Greetings,
Marcel