I have a table containing Caravan make, model and owner details. The ‘Model’ text field contains the caravan model details such as MR18ERS2, MR22BES, MR19ES, MR16ER etc. I want to use a query field to extract the caravan length (characters in position 3 and 4 of the string) Tried using MID( [Model], 3, 2) without success. Hoping someone can help.
Mike