how to decode a string of numbers

[cjlieber]

I'm fairly new to this, so bear with me please!!


I'm trying to decode a VIN and post the results in a table. I only need a couple of digits in the string for information. How do I select specific digits and then relate then to a table?

[RuralGuy]

Look into the Mid() function.

[alansidman]

In a query in a new field, create an expression and use the Find and/or Mid function

http://www.techonthenet.com/access/f...ndex_alpha.php

If you are more specific in your request, we can be more specific in the answer.

[cjlieber]

Look into the Mid() function.

I'm looking to decode A 17 digit number where the first three characters represent the make of the vehicle and the eighth digit represents the model year. what im trying to do is by entering the vin in a box on a form, write some code to fill in the make and year field on that form. I would use values in an excel spreadsheet. IE "1GC" would translate to chevrolet. I have those translations in excel already.

[alansidman]

Here's your query:

SELECT Table1.ID, Table1.VIN, Left([VIN],3) AS Make, Mid([VIN],8,1) AS CarYear
FROM Table1;

Change the field and table names to match your database.

Alan