Extracting a part of a number

  • Thread starter open a adobe file from a command button
  • Start date
O

open a adobe file from a command button

I have some numbers that look like this 1234:231. I would like to extract
everything before the ":" and put in one field and everything after and put
in another. Can I do that with numbers?

Thank You
 
T

Tom Lake

"open a adobe file from a command button"
I have some numbers that look like this 1234:231. I would like to extract
everything before the ":" and put in one field and everything after and put
in another. Can I do that with numbers?

Thank You
Click to expand...


To get the first part you can use Val([yournumber])

to get the second part

Val(Mid([yournumber], Instr([yournumber], ":") + 1))

where [yournumber] is the field that holds your number (surprise!)

Tom Lake
 
Top