JavaScript for field possible?

gilgalbiblewhee

New member
Local time
Today, 06:58
Joined
Mar 19, 2005
Messages
9
I'm new in the MS Access 2000.
I have in a separate place a JavaScript code for a mathematical purpose. I have assigned different characters to different numerical values:
a=1
b=2
g=3
.
.
.
y=10
k=20
.
.
q=100

I was wondering if MS Access 2000 has the ability of taking these characters and calculating ( adding ) them into a separate field? Can the Javascript be somehow entered into the db? I want to use the db with on the web with ASP.

If I addressed this question in the wrong forum if you can please redirect it to the proper one or tell me how to do it. Thanks.
 
This is a "lookup" problem. Create a table that defines the value pairs. Then join to the table on the numeric value to obtain the text value. Use the query in your ASP page. No code is necessary.
 
is there a tutorial on this?

Is there any website on this for more detailed instruction?
 
A tutorial on what? How to create a table? How to write a query that joins two tables?
 

Users who are viewing this thread

Back
Top Bottom