Form to input query criteria between dates

[Harley]

I have this select query.
SELECT DISTINCTROW L160.Date, Avg(L160.Zinc) AS [Avg Of Zinc], Min(L160.Zinc) AS [Min Of Zinc], Max(L160.Zinc) AS [Max Of Zinc], Count(L160.Zinc) AS [Count of Zinc]
FROM L160
GROUP BY L160.Date
HAVING (((L160.Date)=[Forms]![L-160quarterfrm].[Date]));
How do I build a form that would ask the user to input a range of dates for the criteria?
Thanks! )

 

[krunalprajapati]

create two text box date1 and date2 for two dates.
and in query write down as
HAVING (((L160.Date) between [Forms]![L-160quarterfrm].[Date1] and [Forms]![L-160quarterfrm].[Date2]));

hope this helps