Mr Incredible
Distinguished Member
I usually use Excel and am quite familiar with Excel type functions. But I have a need to create an Access database in which I need to calculate a text field from another text field.
This Excel function works a treat:
=LEFT(G3,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},G3&"0123456789"))-1)
Where G3 is the cell in which a full UK post code is present. The above expression strips out the left most characters up to the point where a number character is found. This then becomes my postal region.
Can I create a similar expression in Access using the Left and Instr function? I can't work it out!
Thanks.
This Excel function works a treat:
=LEFT(G3,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},G3&"0123456789"))-1)
Where G3 is the cell in which a full UK post code is present. The above expression strips out the left most characters up to the point where a number character is found. This then becomes my postal region.
Can I create a similar expression in Access using the Left and Instr function? I can't work it out!
Thanks.