What I want to do is take the field [Service Name] and in essence replace many values. There are about 80 different values that may show up here and I need them to be specific verbiage. I tried an update query but was new to those and it seemed I could only do 1 thing at a time? I want to take what is there 'VCP-Cardiology-636A8' and replace it with 'Cardiology' in all records. The data is imported from a source we do not control so I cannot limit how it is sent to us. Trying not to simply look for what is between the -'s as there are some fields where this is not the case. Even if I could make a VBA script somehow that would go through the entire table and just have all 80 lines similar to 'If Me.[Service Name] = "VCP-Cardiology-636A8" Then Me.[Service Name] = "Cardiology". I just can't get that to run through the entire table, only the active record.