Basically in my database I have a field called tagNumber. the tag number has 3 letters and 5 numbers e.g PPY66655. My task is to use an update query to update any number in the tagNumber field with the letters FGR to IRE.
Basically in my database I have a field called tagNumber. the tag number has 3 letters and 5 numbers e.g PPY66655. My task is to use an update query to update any number in the tagNumber field with the letters FGR to IRE.
From : Left(TagNumber,3)="FGR" update to "IRE" & Right(TagNumber,Len(TagNumber-3))