So i am using this to cut down the postcode to just show first two letters and any following numbers
ShortPostCode: Left([post code],InStr([post code]," ")-1)
result : S2
however this is causing a
If i use this code its all Ok, but its not doing what the first code is..
ShortPostCode: Left([post code],4)
result: S2 4
ShortPostCode: Left([post code],InStr([post code]," ")-1)
result : S2
however this is causing a
If i use this code its all Ok, but its not doing what the first code is..
ShortPostCode: Left([post code],4)
result: S2 4