i have database which have two tables (customers & table1)
customer has two field customerid & customername
table1 has eight field in which two field are customerid and date
my problem is this when i retrive data of a customerid between datefrom to dateto in datagrid it will show the data beween datefrom to dateto
but when i am trying to make report acording to this criteria then report shows all the data of that customerid from start to end NOT show between datefrom to dateto
i am using this sql statement to retrive data in datagrid
{"SELECT * FROM Table1, Customers WHERE Customers.CustomerID =Table1.CustomerID AND Table1.CustomerID =" & Customerid & " and Table1.Date between #" & dtFrom & "# and #" & dtTo & "# ORDER BY Table1.DATE"}
is any one can help me in this problem