Hi
I have data stored in a table like my look like this
GXHU - 1245
TS - 124587
What i would like to do is seperate the data by the "-" so in one field there is
GXHU
TS
and in another field
1245
124587
Can this be done with a query?
Reta
Don't ask the same exact question in multiple forums. This question has at least one reply in another thread.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.