Hello all,,

I am a totally beginner in Access, I like to think that I’m a fast learner but I’m stocked with this database for weeks now and mod36 check digit isn’t the only issue, but I thought its better to go one thing at the time, so maybe its better for me to explain once again what I’m trying to accomplish in here, so it will be easier for you to help me. I have a form and in that form I have a Text field (Text1) where I generate a random number like this:

Default Value ="GYM01" & Int((9999999-1000000+1)*Rnd()+1000000)

so i have a 15 characters random string, for example (GYM012547787854)

now, I have another text field (Text2) where I need to add the mod36 check digit to this 15 characters string I generated, meaning in this Text2 I would like to have GYM012547787854 + (check digit, that can be 0 to 9 or A to Z) for example after the "formula or code" it should bring GYM0125477878547 (automatically generated complete 16 digit reference code that I need)

So I’m pretty sure that you can do this, the only thing is for me to know how to put all the code in place

I really appreciate your help and thank you for your time.

Sincerely

toqilula

Hi there..

Why are you doing this??? (9999999-1000000+1)???

Anyway, you need to append the control char to your string?? you can use & to append strings.

What do you mean with all the code in place???

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========