SELECT; " " as MatProblem,; CAST("" AS M) AS Missing,; Curx.Line,Curx.priority,Curx.Customer,; Curx.CUT,Curx.Desc_Cut,Curx.STYLE,Curx.Desc_Style,Curx.DUEDATE,; Curx.total,Curx.totstd,Curx.cutdate,; 00000.00 as timetictot,; 00000.00 as timetic,; 00000.00 as balance,; 00000.00 as diasf,; 0000000.00 as horasf,; DATE() as fec,; 00 as horad; FROM (; SELECT Cut.Line, priority, bname as Customer, cut.CUT, cut.description as Desc_Cut, style.STYLE,; style.description as Desc_Style, DUEDATE, cut.total, totstd,cutdate; FROM cut, cutdtl, style, customer; WHERE cut.custcode = customer.code; AND cut.cut = cutdtl.cut; AND cutdtl.style = style.style; AND duedate >= thisform.text1.Value AND duedate <= thisform.text2.Value; AND EMPTY(dtcompl); AND cut.total > thisform.text10.Value; &lcExtra1 &lcExtra2; DISTINCT) as curx; INTO CURSOR cur1 READWRITE; ORDER BY Priority, DueDate>When you use Distinct, you have to add the memo field afterwards by using Alter Table.