I import data from our Google Drive Sheet.  I can import and append for new records no problem.  I run into a problem when I try to break out the "City, State, Zip" from the imported records.  I did this with another set of data (for Owners, this one is for Contractors).  Richard explains in Access Expert 14 class how to split apart names.  This is the process I am using.  I start with a Select Query and find the Instr value of the comma (,), then use that position to get the city using the left string function, and use the Mid function to find the State and finally the Zip, which works perfectly.  Then I change it to an Update Query and replace the formulas/expression from the SelectQ, how Richard shows in X14 lesson 3 (Seperate First and Last Names).  I get no results.  The one I created earlier for my Owner contacts worked perfectly.  Not sure what I'm doing wrong.  Screenshots to follow.