>What I am trying to do is avoid a 52 week case statement by saving the field i.e. dmd_ as a variable junk_key and store a 1 to count_key. Then I would increment the count_key as needed. Thus, replacing an on_hand field with the field junk_key+alltrim(str(count_key) as needed. This would greatly decrease my coding. When I try the replace I get data type mismatch. Both field are integer. What I am asking is can I save a field as a variable nad use it in a replace statement for another field.
The name expression would work in this case.
junk_key = "dmd_"
count_key = 1
REPLACE ( junk_key + Transform(count_key )) WITH < new value >
--sb--