Hi, I am just starting in Access.
My [Territory Code] field consists of a code with 3 alpha characters(first) and 3 numeric characters(last). I would like a new calculated field to display a 1 when the 3 numeric characters are greater than 899. I would like it to display a 2 when the numbers are between 800 and 899. I would like it to display a 3 when the numbers are less than 800.
I successfully created a new calculated field, [Territory Number] that isolated the 3 numeric numbers. I did it with the following expression in the Field cell of my query:
Territory Number: Right([Territory Code],3)
I have tried multiple combinations of expressions in an attempt to display the level 1,2 and 3 as explained above. I have been in "The Complete Reference - Access 2000" and Access help and Microsoft.com but have been unable to find a good source to adequately explain how to string the expressions together correctly. Any help would be greatly appreciated. TIA, Chris
My [Territory Code] field consists of a code with 3 alpha characters(first) and 3 numeric characters(last). I would like a new calculated field to display a 1 when the 3 numeric characters are greater than 899. I would like it to display a 2 when the numbers are between 800 and 899. I would like it to display a 3 when the numbers are less than 800.
I successfully created a new calculated field, [Territory Number] that isolated the 3 numeric numbers. I did it with the following expression in the Field cell of my query:
Territory Number: Right([Territory Code],3)
I have tried multiple combinations of expressions in an attempt to display the level 1,2 and 3 as explained above. I have been in "The Complete Reference - Access 2000" and Access help and Microsoft.com but have been unable to find a good source to adequately explain how to string the expressions together correctly. Any help would be greatly appreciated. TIA, Chris