Hi all,
I know, I know, I should be posting this on the MS Office/Access forum but I thought I'd give my fellow VFPers a try first.
How do a parse a field that contains two data elements together (i.e. "MA BOSTON " into two separate fields with each individual data element for all the records in a table? In VFP, this would be simple:
REPLACE ALL orgcity WITH SUBSTR(orgcitysta,AT(" ",orgcitysta) + 1)
In Access 97, however, I believe I have to write a module which parses the string (using MID$ function??) and call it from an update query.
Any suggestions?
Thanks for helping a fellow Foxer figure out this cryptic Access thing!
-JT
Jeff Trockman, MCP