Extracting a part of a number

[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

 

[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

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