G
Gemini JD
I need to have 1 of 5 different values added to a field in a table based on
the value of another field. eg. if X is between 1 and 100 make Y=1 OR if X is
between 101 and 200 make Y=2 OR if X is between 201 and 300 make Y=3 OR if X
is between 301 and 400 make Y=4 OR if X is between 401 and 500 make Y=5. The
resultant value is automatically updated on a form and in the underlying
table. I have done this with macros but they are not very reliable. Is there
a way to do this without macros? Access 2000
the value of another field. eg. if X is between 1 and 100 make Y=1 OR if X is
between 101 and 200 make Y=2 OR if X is between 201 and 300 make Y=3 OR if X
is between 301 and 400 make Y=4 OR if X is between 401 and 500 make Y=5. The
resultant value is automatically updated on a form and in the underlying
table. I have done this with macros but they are not very reliable. Is there
a way to do this without macros? Access 2000