Use Insert instead, it's usually easier, faster and better

Insert into SCUsers (RecordID) values (iRecordID)

>I have a table called SCUsers with the folliwng structure:
>
>

>RecordId int
>Data1    memo
>Data3    memo
>Data3    memo
>

>
>When I run the following, I get 'Data Type Mismatch' on both the APPEND BLANK and the REPLACE lines:
>
>

>SELECT SCUsers
>APPEND BLANK
>REPLACE IN scUsers RecordId WITH iRecordId NEXT 1
>

>
>
>The value id iRecordId is Numeric.
>
>Anyone wanna take a stab at this?