Member Avatar for manoj_582033
manoj_582033 0 Light Poster

Hi Friends

I am working in vb.net & ms access, i have a table in which i am saving leave detail means leavefrom & leaveto, records are like 05/12/08 & 10/12/08

I have to controls in front end from where i am passing the value for leavefrom & leaveto
i use the query, where l_from>=textbox1.text and l_to<=textbo2.text
but it is not working properly, when i pass the value 01/12/08 ,31/12/08 it shows record bt when i pass 01/12/08 ,28/12/08 it doesn't show

And when i pass 01/12/08,04/12/08 than also it shows that record which is wrong
So please help me to make it correct

  • 1 Contributor
  • 0 Replies
  • 71 Views
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.