[RESOLVED] Search within date range only

[zynder]

Is there a way I can merge this two queries?


strSQL = "SELECT * FROM TABLENAME WHERE DATEFIELD BETWEEN #" & dtpFrom.Value & "# AND #" & dtpTo.Value & "#"


strSQL = "SELECT * FROM TABLENAME WHERE ANYFIELD LIKE 'ANYKEYWORD%' ORDER BY ID"


The first query is for date range. The next query is a normal query for keywords. I want to use the second query BUT will only search between the date ranges of the first query.

If only I could merge the two. Is this possible? Something like this.

strSQL = "SELECT * FROM TABLENAME WHERE ANYFIELD LIKE 'ANYKEYWORD%' AND WHERE DATEFIELD BETWEEN '" & dtpFrom.Value & "' AND '" & dtpTo.Value & "'" ORDER BY ID"

By the way, I am using SQL Server. Thanks for the help.

[vksingh24]

You can use this
strSQL = "SELECT * FROM TABLENAME WHERE (DATEFIELD BETWEEN '" & dtpFrom.Value & "' AND '" & dtpTo.Value & "'") AND (ANYFIELD LIKE 'ANYKEYWORD%') ORDER BY ID

[zynder]

Ahh. Is that it? You mean im only missing a parenthesis? I'll try that out.

[zynder]

Thanks! Post rated. I made myself a fool.

[si_the_geek]

The parenthesis aren't strictly needed, but are a good idea (they make it clearer, and reduce mistakes when you have a mixture of And/Or).

The important thing is that you had WHERE twice, and it should only be used once.

[zynder]

Yeah. Thanks a bunch!