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.

give date value as

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

i hope it will work try it

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

Hi, Are you forget WHERE Clause or typo mistake?

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.