Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

problem writing report

rashid83rashid83 Member Posts: 11
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

Comments

  • Termc1224Termc1224 Member Posts: 84
    : 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
    :
    Try checking your sql in the report. it should have the same sql in your datagrid
    I'm the best there is,
    the best there was,
    and the best there ever will be.
    hahahahaha lolz :)
Sign In or Register to comment.