Doh!
I'm not carrying over the value from record to record. All I need is a variable to store it to.
Double doh!
>Showing it where? Your replace command seems somewhat at odds with what you are saying you want to do. The replace will replace each row with the content of it's own header1. It won't be concatenating header1's together.
>
>>Very interesting. That solves the problem in the command window using variables, but the memo field is still only showing the last value.
>>
>>>Jay,
>>>
>>>It's a display time thing. Your values are overwriting each other because you only issue a carriage return. If you add a linefeed you should see what you are expecting.
>>>
>>>
>>>SCAN
>>> REPLACE Header1Text WITH Header1Text + ALLTRIM(Header1) + CHR(13) + chr(10)
>>>ENDSCAN
>>>
>>>
>>>>Let's say there are 3 records in the open table and the values of Header1 are all different. If I use "CHR(13)" then I only get the last value of Header1 in the Header1Text field. If I use a character, like "|" then I get all three values concantenated together separated by the "|" character. Why am I losing the first two values when I use "CHR(13)?" I can also duplicate this behavior in the command window using variables.
>>>>
>>>>
>>>>SCAN
>>>> REPLACE Header1Text WITH Header1Text + ALLTRIM(Header1) + CHR(13)
>>>>ENDSCAN
>>>>