cut off a number

  • Thread starter Thread starter Dan
  • Start date Start date
D

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?
 
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.
 
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?
.
Click to expand...
.
Click to expand...
 
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?
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top