In Access in the AT function is INSTR. In your case you can probably use Left(orgcitystate, 2) to get the state and Mid(orgcitystate, Instr(orgcitystate, " ")) to get they city. I hope this helps.
Stephen Kuhn
Prism Network, Inc.
System Developer
At last we can reveal ourselves to the Jedi.
At last we will have revenge.
-Darth Maul
