Input Mask

[Guest]

Thanks in advance

My Accesss table (Sheet1) has a field named "VIN".
This is an automobile VIN number, 17 alphanumerical long.

I want to create an another columm in the same table (Sheet1) to be named as
""Custom VIN": last 8 numbers taken from "VIN" field.

Thank you.

 

[Jeff Boyce]

Jay

I may be reading too much into your description, but it sounds like you are
describing a spreadsheet, not a relational database.

Tables store data in Access, while queries retrieve it. Instead of adding a
(redundant) field to your table, why not use a query to return the
right-most 8 characters of your [VIN] field? Something like:

Right([VIN],8)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

Thanks in advance

My Accesss table (Sheet1) has a field named "VIN".
This is an automobile VIN number, 17 alphanumerical long.

I want to create an another columm in the same table (Sheet1) to be named as
""Custom VIN": last 8 numbers taken from "VIN" field.

Thank you.

This a) has nothing whatsoever to do with an input mask (which merely
controls what you can type into a field or control), and b) should
certainly NOT be done in a table. Storing data redundantly in the
table is neither necessary nor beneficial.

Instead, create a Query based on your table; in a vacant Field cell in
the query type

Custom VIN: Left([VIN], 8)

This Query can then be used as the basis for a Form, a Report, for
export, anything you can do with the table (except for editing the
Custom VIN, which I'd guess you don't want to do anyway).

John W. Vinson[MVP]

 

[Jeff Boyce]

Hi, John.

Since Jay was describing using the last 8 characters, I'm sure your fingers
slipped and you meant to use Right().

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks in advance

My Accesss table (Sheet1) has a field named "VIN".
This is an automobile VIN number, 17 alphanumerical long.

I want to create an another columm in the same table (Sheet1) to be named
as
""Custom VIN": last 8 numbers taken from "VIN" field.

Thank you.

This a) has nothing whatsoever to do with an input mask (which merely
controls what you can type into a field or control), and b) should
certainly NOT be done in a table. Storing data redundantly in the
table is neither necessary nor beneficial.

Instead, create a Query based on your table; in a vacant Field cell in
the query type

Custom VIN: Left([VIN], 8)

This Query can then be used as the basis for a Form, a Report, for
export, anything you can do with the table (except for editing the
Custom VIN, which I'd guess you don't want to do anyway).

John W. Vinson[MVP]