URGENT! select date1 until date2 and more field Help Please...

i use date as date/time on ms access
but i just want to select the date from 01/01/2006 until 10/01/2006 with
the driver is 2111 with group north and with speed from 24 until 90

mstrSQL = "SELECT * from dss WHERE (Date>= #" &
DTdate1.value & "#) AND (Date<= #" & DTdate2.value & "#)"
AND driver='" & txtdriver.text & "'" AND group='" & txtgroup.text & "'"
AND (speed >='" & txtspeed1.text & "'") AND (speed <='" & txtspeed1.text & "'")

but still not show :(
anybody can tell me whats wrong about the sql statement?
help me

joanleonz,your using Date as a field name is a lot suspicious!Date is supposed to be a reserved word,how can you use it as a field name?Try changing it.
Hi soft,
if you look carefully, you'll see that Date is inside a sql query String, and therefore cannot be confused with a keyord...
In this context, it is the name of a recordset field
Marco

i have good experience with vb
but i have some serious problems
i have created a mysql with table dss
but i`m confused about this
i think many people will see this problem in future
this is the table of dss

--------------------
Date | Drivers | Group | Speed | Score |
--------------------
01/01/2006 2111 north 64 98
02/01/2006 2121 north 53 95
03/01/2006 2145 north 43 96
04/01/2006 2187 south 77 94
05/01/2006 2133 north 35 92
06/01/2006 2165 south 38 100
07/01/2006 2181 north 38 80
08/01/2006 2135 north 42 60
09/01/2006 2111 north 43 44
10/01/2006 2124 south 41 85
11/01/2006 2113 north 45 82
12/01/2006 2109 north 75 96
13/01/2006 2106 north 75 99
14/01/2006 2111 north 75 87
15/01/2006 2123 south 90 56
------------------

then i want select the date from 01/01/2006 until 10/01/2006 with
the driver is 2111 with group north and with speed from 24 until 90 with score from 50 until 100 and show it into datagrid
but i can selected any in checkbox and unselected to show what field i just wanna filtered

i made date with dtpicker and drivers,group speed and score with textbox
then i made selected field that i want to filtered with checkbox
this is the details
==================================
check1.value for date
check2.value for drivers
check3.value for group
check4.value for speed
check5.value for score
==================================
date1 = dtpicker1.value
date2 = dtpicker2.value
drivers = txtdrivers.text
group = cbogroups.text (combo box)
speed = txtspeed1.text and txtspeed2.text
score = txtscore1.text and txtscore2.text
==================================
this is a link the picture of the forms
http://www.geocities.com/joanleonz/forms.gif
please help me what kind of code what must i have

please help me? URGENT!

thanks

:(

details of the tables of dss
======================
date (data type = date)
drivers = (Data type = text)
groups ( data type = text)
speed ( data type = text)
score ( data type = text)
=====================
i want select the date from 01/01/2006 until 10/01/2006 with
the driver is 2111 with group north and with speed from 24 until 90 with score from 50 until 100 and show it into datagrid
but i can selected any in checkbox and unselected to show what field i just wanna filtered

i made date with dtpicker and drivers,group speed and score with textbox
then i made selected field that i want to filtered with checkbox
this is the details
==================================
check1.value for date
check2.value for drivers
check3.value for group
check4.value for speed
check5.value for score
==================================
date1 = dtpicker1.value
date2 = dtpicker2.value
drivers = txtdrivers.text
group = cbogroups.text (combo box)
speed = txtspeed1.text and txtspeed2.text
score = txtscore1.text and txtscore2.text
==================================
this is a link the picture of the forms
http://www.geocities.com/joanleonz/forms.GIF
please help me what kind of code what must i have
i write some code
mstrSQL = "SELECT * from dss WHERE (Date>= #" &
DTdate1.value & "#) AND (Date<= #" & DTdate2.value & "#)"
AND driver='" & txtdriver.text & "'" AND group='" & txtgroup.text & "'"
AND (speed >='" & txtspeed1.text & "'") AND (speed <='" & txtspeed2.text & "'") AND (score >='" & txtscore1.text & "'") AND (score <='" & txtscore2.text & "'")

but still not showing
i`m so confused
any good answer?
help me please........

Try this one...

"SELECT * from dss WHERE (Date>= #" &
DTdate1.value & "#) AND (Date<= #" & DTdate2.value & "#)
AND driver='" & txtdriver.text & "' AND group='" & txtgroup.text & "'
AND (speed >='" & txtspeed1.text & "') AND (speed <='" & txtspeed2.text & "') AND (score >='" & txtscore1.text & "') AND (score <='" & txtscore2.text & "')"

gupex was right.. it might be only a typo, you got extra "(double qoutes) in your query :D and a missing "(double qoute) in the end of the query :( . tell me if this helped you. :WAVE:

Work with something like this ...

bAtLeastOne = False

mstrSQL = "SELECT * from dss WHERE "

(if bAtLeastOne is False at the end of all the checks, then don't run query - unless you want
'ALL' (in which case remove 'WHERE') - although you could cater for this in the first time
you set bAtLeastOne to true by adding ' WHERE ')

If chkDate.Value = vbChecked then
mstrSQL = mstrSQL & "(Date>= #" & DTdate1.value & "#) AND (Date<= #" & DTdate2.value & "#)"
bAtLeastOne = True ' This is to only have 'AND' if you already have one parameter
EndIf

If chkDrivers.Value = vbChecked Then
if bAtLeastOne Then
mstrSQL = mstrSQL & " AND "
EndIf
mstrSQL = mstrSQL & " driver='" & txtdriver.text & "'
bAtLeastOne = True
EndIf

etc ...

The following code appears twice in your last post :-

"mstrSQL = mstrSQL & mstrSQL = mstrSQL & "(whatever)"

remove the second "mstrSQL = mstrSQL & " leaving :-

"mstrSQL = mstrSQL & "(whatever)"

Put a breakpoint on the line :-

"rsdss.Open mstrSQL, con, adOpenStatic, adLockOptimistic"

and see what mstrSQL contains (try and run the query in Access or whatever database you are using).

As per previous post ...

Put a breakpoint on the line :-

"rsdss.Open mstrSQL, con, adOpenStatic, adLockOptimistic"

and see what mstrSQL contains (try and run the query in Access or whatever database you are using).

Please advise contents of mstrSQL at this point.

Greg