hi please anybody provide me solution. i have added dataset from toolbox and drag and drop datatable from toolbox then i  retrieve  the fields from two table which table name is inv,inv_mat. then
 i written query (   str = "SELECT a.mat_name,a.qty,a.rate,a.trate,b.invoice_no,b.invoice_Date,b.comp_name FROM  inv_mat a,inv inv where a.invoice_No=b.invoice_No"
        str &= " And inv.invoice_date >=#" & Format(date1, "MM/dd/yyyy") & "# AND b.invoice_date <=#" & Format(date2, "MM/dd/yyyy") & "#"
     ) field is displayed except invoice no field.


thanks in advance