Tht did it. Thanks Craig and Joel.



>Ntot quite. The field name is actually "PCD_POWER_" followed by a space and the letter C, indicating a Character field. My guess is the export from Clarion did it's best to create field names of 10 characters or less and truncated the rest of the field name.
>
>Make the second instance "PCD_POWER2" and it *should* work. Just change it in the hex editor.
>
>>My client said the tables come from Clarion. When I open one in hexedit I do see what appears to be duplicate column names.
>>
>>See this:
>>http://www.maroisconsulting.com/stuff/hexedit.png
>>
>>I have not used this tool before. It looks like column "PCD_POWER_C" appears twice.
>>
>>How do I try to change the column name?
>>
>>Thanks