Adding Check Digits

  • Thread starter Thread starter John Reynolds
  • Start date Start date
J

John Reynolds

I have a field which contains a list of codes in the
format below:

C123456

I want to add a check digit on the end of this based on
137137 fomula

So for the example above I get the following result:

C1234569.

Does anyone know how I can go about doing this?

Also it would be useful if I can somehow validate the
check digit on data I already have in the field. Is there
anyway I can do this?
 
John

If you have a formula that creates a check-digit, couldn't you write a
function that uses that formula?

What am I missing...?

Jeff Boyce
<Access MVP>
 
John

First, you won't "apply it in your table". Tables in Access hold data.
Forms are used to add/edit that data.

Formulas can be entered in queries, as expressions, in forms, as "code
behind form", and in modules, as procedures.

If you'll post the formula, readers may be able to offer more assistance.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top