Date range query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the follwing syntax, and it's not working on the date selection
criteria. Any ideas what I'm doing wrong?

Thanks!

recSet2.Open "SELECT * from [Service Provider Rate Detail] where [Rate
Effective Start Date] <= " & ws_service_date_from & " and " & _
"[Rate Effective End Date] >= " & ws_service_date_from
 
Dates require the # delimiter:

recSet2.Open "SELECT * from [Service Provider Rate Detail] "_
& " where [Rate Effective Start Date] <= #" & ws_service_date_from & "#"
_
& " and [Rate Effective End Date] >= #" & ws_service_date_from "#"

HTH,
Debbie


|I have the follwing syntax, and it's not working on the date selection
| criteria. Any ideas what I'm doing wrong?
|
| Thanks!
|
| recSet2.Open "SELECT * from [Service Provider Rate Detail] where [Rate
| Effective Start Date] <= " & ws_service_date_from & " and " & _
| "[Rate Effective End Date] >= " & ws_service_date_from
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query - return data for each day within a date range 2
Access crashes on a subquery 7
Unlikely error msg from query 2
Query to work out which rate should be inserted 2
Finding the date of last pay rise 8
SQL Mix up? 3
Date Query 1
MAX DATE 5

Back
Top