Ok, so I’ve searched high and low, found out how to replace text in VBA with a function, but cannot find the expression to use in an update query or code to replace through a macro the value “MW” with “MO”. I have a column, called [rstat] which is created through an update query that runs when my database opens. It is created by combining two values, Rank, and Service. I have three basic types of ranks, E*, O* and W*, and service USMC or USN. The query populates the RSTAT column by combining the third letter of service and the first letter of rank. The kink in the works is that when I run crosstab queries, I get MO, MW, ME, NO, NE. MO and MW are both individuals of the same type, and should be counted together. After my update query is ran, I would like to replace MW with MO in the RSTAT column. I hope that is descriptive enough.
Thanks
Jeremy
Oops.
