You need some sort of conversion routine.
One approach could be a lookup table to substitute a value for a specific value.
Code:
FieldValue SubstituteValue
horse animal
dog animal
cow animal
rose flower
daisy flower
You would replace occurrences of fieldvalue with the associated substituteValue. You would not change the original values.
What you would do is create a query and replace found values with the substituted values and use that query as the recordsource of the report. Your original data would not be changed.
Consider an original, saved record
Mary had a little lamb, she also owned a horse
then using the substitution routine (yet defined but concept)
converted for further processing
Mary had a little lamb, she also owned a animal
but the original remains
Mary had a little lamb, she also owned a horse
Simple routine for this example
Code:
Sub testsub4()
Dim str As String
str = "Mary had a little lamb, she also owned a horse"
Debug.Print Replace(str, "Horse", "animal") & vbCrLf & str
End Sub