Hi,
Please can you help me find a way to display the left (or first) 13 characters of a field and also the right 13 characters in the same field as I need to display them separately in 2 different fields on a form. Below is what I have but cannot work out how to integrate left and right in to it.
'=DLookUp("Caption","PLUCaption","Code='1318'")'
Many thanks,
Malcolm
Please can you help me find a way to display the left (or first) 13 characters of a field and also the right 13 characters in the same field as I need to display them separately in 2 different fields on a form. Below is what I have but cannot work out how to integrate left and right in to it.
'=DLookUp("Caption","PLUCaption","Code='1318'")'
Many thanks,
Malcolm