I have a table with business addresses [Address1]. I need to sort by [Street_Name] only (I have moved the street number to a separate field) so I can drive to them efficiently. Some of the addresses include a Ste at the end of the address.
The problem is when I sort and group by street name, Maple St is considered a different street than Maple St Ste 105.
I have a query that removes the Ste number portion from [Street_Address]. I use StePos: InStr([Street_Name]," Ste ") to determine the position of the Ste portion if present. I use SteRemoved: IIf([StePos]=0,[Street_Name],Left([Street_Name],InStr([Street_Name]," Ste ")-1)) to remove the Ste portion. This is in a Select Query and works perfectly.
The problem is I can not create an Update Query from the Select Query to update the table containing [Street_Name] to show streets with the Ste portion removed. I get a dialog  box Enter Parameter Value for StePos. If I click Ok and run the query, it fills [Street_Name] with blanks. Fortunately, I have backups of everything thanks to your famous slide. How do I create an Update Query using the above expressions to update the table?

I have watched dozens of Update Query videos but none address updating using a calculated field like I am using. Thanks for your help.