MS Access Date filter basedon User Input

[shanmugamgsn]

Hi Friends,

I have query in MS access which does date filter based on value given by user.


SELECT *
FROM Table1
WHERE ((DateValue([Table1].[Date_col])


Between "#"&[Forms]![Frm1]![Date1]&"#"
and "#"&[Forms]![Frm1]![Date2]&"#"))


But this gives empty output

[RayMilhon]

It's your between statement Change it to
Between DateValue(forms!frm1!date1) and DateValue(Forms!frm1!date2)