SELECT  cust_no, field1, field2, IIF(table2.Field3>5,Table2.Field3, SPACE(len_of_field3)) AS Field3;
               FROM table1;
               LEFT JOIN Table2 ON Table1.Cust_no = Table2.Cust_No;
              INTO CURSOR cCursor

Is that what You need?


>Have table1 with cust_no, field1, field2. table2 has cust_no, field3. want to create a table with table1 fields and table2.field3 if field3 > 5. Want to end up with the same number of record from table1.
>
>The WHERE field3 > 5 makes me lose records from table1.
>
>thanks
>
>Brenda