Expression trouble

[Confu]

I've got a field that contains employee Id numbers that I'd like to be able to by, the problem is that temporary employees are given id numbers with a v at the beginning. So id numbers would show as:
232
3567


68901
V4156
V24567
To be able to sort this accurately I'm trying to create an expression that checks if it has the v and if so only takes the numbers from the other side and adds 100000 since no id is in that range and I could still accurately sort with that field.
I've tried:
Iif(left([emplid]),1="V",(iif(len([emplid])=6, right([emplid],5)+100000),right([emplid],4)+100000),abs([emplid]))
Which instead of getting 104156 and 124567
In place of v4156 and v24567 I just get 100000 for both.

I've also tried testing:
Iif(len([emplid])=6,right([emplid],5)+100000), right([emplid],4)+100000)
Which results with replacing the v like i want but also effects the numbers without the v.

Edit:
So right after I posted I tried adding parenthesis at (left([emplid],1))="V" to the top expression and it worked but it still sorts by first number so sort looks like:
1
10
10000
2
2000
When I need:
1
2
10
2000
10000
I've tried using abs() around the whole expression but it doesn't seem to affect it.

[lfpm062010]

Use this.

Iif(left([emplid],1)="V",iif(len([emplid])=6, CLng(right([emplid],5))+100000,CLng(right([emplid],4))+100000),abs([emplid]))

[Confu]

Use this.

Iif(left([emplid],1)="V",iif(len([emplid])=6, CLng(right([emplid],5))+100000,CLng(right([emplid],4))+100000),abs([emplid]))

I tried inputting that but it says cannot be used in a calculated column. I assume it was CLng function because it doesn't auto fill when I type it in.
Edit:
Alright so I was able to input that into criteria of a query but when I sort it still doesn't sort by value but rather first character

[John_G]

You really should try to avoid using calculated columns (fields) in a table - use a query instead.

Put an expression field in your query and use the expression for sorting (you don't have to display it).

Something like this should work:

iif(left([emplid],1) = "V", val(mid([emplid,2])), val([emplid]))

[Confu]

Thanks, solved my problem. Never been proficient at access and its been years since I last used it.