why is this happen?
[Originally posted by ifah]
i have 1 combo box here which list type of book : Education, Horror,
Romance and Kids.
i also have 2 DateTimePicker here.
My question here is how to generate a report that will show data when
i choose 'Horror' from Combo1 and the data is between the 2 DateTimePicker.
example ( user put this in his combo box and DTPickers):
Combo1.Text = 'Horror'
DTPicker1.Value = 01/09/20001
DTPicker2.Value = 05/09/2001
i done this in:
Dim strSQL as string
strSQL = "SELECT * FROM tblMyBooks WHERE BookType=''" & Combo1.Text & "'' AND (BookDate Between #" & DTPicker1.Value & "# AND #" & DTPicker2.Value & "#);"
the problem is, the report show all data from the table. the report did not show data
that i want like in my strSQL.
is there anything wrong here?
could anybody please tell me why?
thanks in advance!!
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL