cut off a number

[Dan]

i have a table which has numbers in it for example

3256
2156
1234
5411

is there a way to cut off the first number in each like
the 3,2,1,5 and leave what is left?

 

[Les]

The following will work if your numbers are all 4 digits
long: Mid([numfield],2,3)

It's starting at the 2nd position in the field, and
selecting 3, bypassing your first position.

 

[Dan]

now say i wanted to add a 1 in front of each one of those
numbers for example in front 256 and make it 1256
256
156
321

-----Original Message-----
The following will work if your numbers are all 4 digits
long: Mid([numfield],2,3)

It's starting at the 2nd position in the field, and
selecting 3, bypassing your first position.

-----Original Message-----
i have a table which has numbers in it for example

3256
2156
1234
5411

is there a way to cut off the first number in each like
the 3,2,1,5 and leave what is left?
.

.

 

[John Spencer (MVP)]

Add 1000 to the number

YourField + 1000

Another method to drop the first digit of the number would be to use the mod operator

YourField Mod 1000

now say i wanted to add a 1 in front of each one of those
numbers for example in front 256 and make it 1256
256
156
321

-----Original Message-----
The following will work if your numbers are all 4 digits
long: Mid([numfield],2,3)

It's starting at the 2nd position in the field, and
selecting 3, bypassing your first position.

-----Original Message-----
i have a table which has numbers in it for example

3256
2156
1234
5411

is there a way to cut off the first number in each like
the 3,2,1,5 and leave what is left?
.

.

 

[Van T. Dinh]

([YourNumber] MOD 1000) + 1000

should change the first digit to 1.