split a number

Topic

New Reply

how can i split a number into two parts
like take 12.8862 and put
12 in one textbox and 8862 in another
i’m using access 2000
thanks for any help
JerryC

Reply | Quote

Replies

There’s probably a better way, but this will work. [txtMyNumber] contains 12.8882 — Int([txtMyNumber]) will return the integer value “12” and [txtMyNumber]-Int([txtMyNumber]) will return the remainder “0.8882”

Reply | Quote

thanks
worked like a charm
JerryC

Reply | Quote