Best way to Calculate from List of years

[hartmut77]

Hello

The 10th digit in a VIN number reflects the year the car was manufactured.

A 1980 B 1981 C 1982 D 1983 E 1984 F 1985 G 1986

[zincb]

Calculated Numeric field:

Case(

Middle( vin, 10, 1) = "A", 1980 ,

Middle( vin, 10, 1) = "B", 1981 ,

Middle( vin, 10, 1) = "C", 1983 ,

...ETC...

Middle( vin, 10, 1) = "2", 2002,

Middle( vin, 10, 1) = "3", 2003,

2004

)

[hartmut77]

Thanks very much for you help

Dave

[BobWeaver]

This would also work:

Position("ABCDEFGHJKLMNPRSTVWXY12",Middle(VIN,10,1),1,1)+1979