query not working

[pardeep3dec]

Hi friends,
my query not worked.
rc.open"select * from travel doj between #"& doj.text &"# AND #"& doj1.text &"#;
suppose
doj.text=01/09/2008
doj1.text=22/09/2008

but it shows july records also.

[guest11]

give date value as

doj.text=09/01/2008
doj1.text=09/22/2008

i hope it will work try it

[debasisdas]

you need to format the date properly before passin gthat to database for processing

[selvaganapathy]

Hi, Are you forget WHERE Clause or typo mistake?

SQL = "SELECT * FROM travel WHERE doj BETWEEN #" & doj.text & "# AND #" & doj1.text  & "#;"

[venkatramasamy]

HI,

You better to store the Taxtbox value in Date Variable,

Dim FrmDate as date
Dim ToDate as Date

FrmDate=doj.text
ToDate=doj1.text

SQL = "SELECT * FROM travel WHERE doj BETWEEN #" & FrmDate & "# AND #" & ToDate  & "#;

Hope this will help you,

With regards
Venkatramasamy SN