Date range query?

D

Dennis

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
 
D

DebbieG

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
 
Top