Access VBA Macro

We need a custom Access macro that will perform the same function as the existing "rpt2" macro (see attached Access db), but will first do a search and replace of certain values in the input table. The rpt2 macro takes the rpttrades table and outputs the data to a file. We need the macro to replace certain values from the staccid field. If brshort == "ACG" then the value of the staccid field should become "123456" in the output file. We need to be able to add more conditions like this as the need arises. The output file should have the name of [login to view URL] We are currently working with Microsoft Access 2000 but it should be possible for the module to work in the latest versions of Access.