Im using a access mdb file that contains some datas. How can I send them into datareport page for example i have to send only datews between 01/01/2005 and 01/01/2006.. Or is there any way to do it into datagrid ?
Printable View
Im using a access mdb file that contains some datas. How can I send them into datareport page for example i have to send only datews between 01/01/2005 and 01/01/2006.. Or is there any way to do it into datagrid ?
Hi Galatyali!!!
Try creating a query first in ms Access database that will display the dates...You may either use an SQL statement using SQL view or just manipulating (between)...Then add a data environment bound to that query...Quote:
Im using a access mdb file that contains some datas. How can I send them into datareport page for example i have to send only datews between 01/01/2005 and 01/01/2006
After that, add rpttextboxes for the fields bound to that query...
Greg
:) :) :)
Sorry mate but i didnt understand what ur trying to explain. anyway I already have a database so i need teh code or something to put in a commandbox thats all. i dont know how to use sql :(
I don't think you meant to create a whole new thread, so I merged the one you created with this one. :)
You could try something like...
VB Code:
SELECT * FROM Table WHERE DateField BETWEEN Date1 AND Date2
I can list my data between dates im asking how can i send them into datareport to print or is there any other way that prints datagrids list....