On the worksheet you fill in the dates in the format of dd/mm/yyyy, like 04/12/2007. In your coding you'll have to rearrange the format like this [VBA]"WHERE MyDate BETWEEN #" & _
Format(Worksheets(1).Range("A1").Text, "yyyy/mm/dd") & "# AND #" & _
Format(Worksheets(1).Range("A2").Text, "yyyy/mm/dd") & "#"[/VBA]But it could be that the in between dates aren't included. You'll have to test on that one.