Extracting a part of a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
"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


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
 
Back
Top