Search between dates...............

[spud]

I have a Access database attached to my Vb prog it has names and dates of when people are off work and the date they come back to work.

I have the SQL to search the name and the date when they go off work but I wouldnt know where to start to show if they are off work between that date and the date they return from holiday.


Any one any Idea how I do this?


thx

[Nintendo_Wizard]

Have you tried an Oledbparameter? This is the easiest way for me to search between dates:

' SQL Stmt
SELECT Date1, Date2 'Include the rest of you column names
WHERE ([Date1] <= ?) AND ([Date2 >= ?]) 'this established a parameter
FROM TableName

Then assign your parameter to the value of your object. (txtbx, dateTimePicker, ect.).