extract value

[stevenszoe]

i need assistance extract the following

12345 from 3001-12345Y
653 from 2007-653Z
23 from 4009-23p

the number of places after the dash will be variable. I have tried using
the following with a field named test, but getting #Error when run query

Expr1: Mid([test],InStr([test],"-",1)+1,Len([test]-InStr([test],"-",1)-1))

 

[JLamb]

There is a misplaced parentheses:

Mid([test],InStr([test],"-",1)+1,Len([test] ) -InStr([test],"-",1)-1)

 

[stevenszoe]

still getting #Error.

HELP!

There is a misplaced parentheses:

Mid([test],InStr([test],"-",1)+1,Len([test] ) -InStr([test],"-",1)-1)

i need assistance extract the following

12345 from 3001-12345Y
653 from 2007-653Z
23 from 4009-23p

the number of places after the dash will be variable. I have tried using
the following with a field named test, but getting #Error when run query

Expr1: Mid([test],InStr([test],"-",1)+1,Len([test]-InStr([test],"-",1)-1))

 

[JLamb]

The last Instr parameter is unnecessary and is throwing off the calc. This
works:

Mid([test],InStr([test],"-")+1,Len([test])-InStr([test],"-")-1)

still getting #Error.

HELP!

There is a misplaced parentheses:

Mid([test],InStr([test],"-",1)+1,Len([test] ) -InStr([test],"-",1)-1)

i need assistance extract the following

12345 from 3001-12345Y
653 from 2007-653Z
23 from 4009-23p

the number of places after the dash will be variable. I have tried using
the following with a field named test, but getting #Error when run query

Expr1: Mid([test],InStr([test],"-",1)+1,Len([test]-InStr([test],"-",1)-1))

 

[stevenszoe]

that worked. thanks much!

The last Instr parameter is unnecessary and is throwing off the calc. This
works:

Mid([test],InStr([test],"-")+1,Len([test])-InStr([test],"-")-1)

still getting #Error.

HELP!

There is a misplaced parentheses:

Mid([test],InStr([test],"-",1)+1,Len([test] ) -InStr([test],"-",1)-1)


:

i need assistance extract the following

12345 from 3001-12345Y
653 from 2007-653Z
23 from 4009-23p

the number of places after the dash will be variable. I have tried using
the following with a field named test, but getting #Error when run query

Expr1: Mid([test],InStr([test],"-",1)+1,Len([test]-InStr([test],"-",1)-1))