How to compare memo fields?

[carlcrespo]

I have a memo field named COMMENT. I need run an if statement similar to:__IIF(COMMENT=PREVIOUS(COMMENT), ^^,COMMENT)____Or how to convert a memo to a string and then use it in a Calculated field.____The only way I found to do it in R&R is to export to a text file.____Thanks in advance, Carl

[kfleming]

The previous function will not let you test memo fields. No way around this restriction.____Kathleen__R&R Support

[carlcrespo]

>The previous function will not let you test memo fields. No __>way around this restriction. __>__>Kathleen __>R&R Support ____How do I compare or delete duplicate memo records? My company stores names in a memo fields. ____Can memo fields converted to strings using calculated fileds?

[Greve]

I have also run into limitations reporting on memo fields for one of my clients. As a workaround, I created a FoxPro program to convert the memo fields to character fields and then report against the converted table with char fields. I also scheduled the program using Windows Scheduler to run at night so that the data is up-to-date as of "yesterday".____Hope this helps,____Rob