Thank you. That worked. Appreciate the assistance.
>>Howdy,
>>Scanning a table and as I go through the records, want to insert records into another table. One field can be valid in the source table, so I want to update the destination record/field with "No Listing provided", else inset the data with the source field/data.
>>
>>Here's is the code:
>> *Scan Sourcetable
>> * insert into NewTable (field A, Field B, Field C) values (SourceTable.FieldA, SourceTable.FieldB, iif empty(allt(sourceTable.fieldC)), "No LIsting Provided", allt(sourceTable.fieldC))
>>
>
>Hi,
> * insert into NewTable (field A, Field B, Field C) values (SourceTable.FieldA, SourceTable.FieldB, iif(empty(allt(sourceTable.fieldC)), "No LIsting Provided", allt(sourceTable.fieldC)) )
>
>MartinaJ
>>Receiving a syntax error.
Thanks in Advance.
J. Turner