I put 2 dtpicker in my project. both are for search data from backed access file. like (1st dtpicker) i select a date 16/08/08 and (2nd dtpicker) 16/09/08. i want to find data last a month or any few days. i mean i want to find a period data like a month or a week or other. what code i will write for it. please help me
abu taher
34
Practically a Posting Shark
Recommended Answers
Jump to Postusing between or operator ">" and "<".
Jump to PostSELECT * FROM participants WHERE Date between DTPicker1.Value and DTPicker2.Value
All 5 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
dnk
commented:
Right...
+1
abu taher
34
Practically a Posting Shark
Jx_Man
987
Nearly a Senior Poster
Featured Poster
abu taher
34
Practically a Posting Shark
Jx_Man
987
Nearly a Senior Poster
Featured Poster
abu taher
commented:
thanks a lot.
+1
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.