Text Field IIf Statement

[dee]

I have an employee field that contains a number, but has been set as a text
field as there was no need for calculation.

However, I now have been asked to assign a particular code to the employees
whose numbers are between 1 and 100 and another code if between 101 and 200
and another if between 201 and 300.

Any help would be greatly appreciated!

 

[Jeff Boyce]

Can you create a query that derives these? You might not need to actually
assign a code if you can use a query to derive (i.e., calculate) it.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[mscertified]

You could use CInt() function to force the string to an integer

-Dorian

 

[Klatuu]

IIf([EmpNum] <=100,"A",IIf([EmpNum] <= 200,"B","C"))

 

[dee]

Hi there,

Thanks so much for your response. I tried this, but received a type
mismatch error. I must be doing something wrong.
--
Thanks!

Dee

IIf([EmpNum] <=100,"A",IIf([EmpNum] <= 200,"B","C"))
--
Dave Hargis, Microsoft Access MVP

I have an employee field that contains a number, but has been set as a text
field as there was no need for calculation.

However, I now have been asked to assign a particular code to the employees
whose numbers are between 1 and 100 and another code if between 101 and 200
and another if between 201 and 300.

Any help would be greatly appreciated!

 

[Ron2006]

if [EmpNum] doesn't work try changing each part of that expression
to CInt([EmpNum])

Ron

 

[dee]

Thanks for your response. I tried what you suggested, but get a type
mismatch. I must be doing something wrong.

 

[dee]

Got it to work with an Iif statement! Thanks so much to you all!!