Left (Text;number) Function
I have made a field that should return the last four text from another field.
It basically looks like this...
Field 2 = left(Field 1;4)
Now the only issue I'm having is that Field 2 won't populate unless I go in and recommit some of the values in Field 1. So for field 2 to show anything I basically have to go into field 1 and erase the last letter, retype it and then click out of the box. I have over 4500 records that I need this calculation to work for. So recommitting field 1 in every record is not really an option. Could someone help me figure out a way around this? So that field 2 automatically pops up?