Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data manipulation

Status
Not open for further replies.

reta

Technical User
Dec 23, 2004
51
AU
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top