Update. I made a mistake. Now I realise that field3 is numeric:
<SELECT cust_no, field1, field2, IIF(table2.Field3>5,Table2.Field3, 0000000) AS Field3; && You must add so much zeros as LEN of Table2.Field3FROM table1;
LEFTJOIN Table2 ON Table1.Cust_no = Table2.Cust_No;
INTOCURSOR cCursor
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.