>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.

Thanks for the info, Steve - I'm sure this will be helpful. I need to do this for every record in the table - should I use an update query or write a module that scans the table?

Thanks again for you help!

-JT