Having Trouble with working with dates

SELECT DISTINCTROW format$([dbo_rptASample].[Date],'Long Date') As [Date By Day], Ave(dbo_ASample.Value)AS[Ave OF Value], Min dbo_ASample.Value)AS[Min Of Value], FROM dbo_ASample
GROUP BY [dbo_ASample.Value].[Date],dbo_ASample.Value.TrendNdx
HAVING (((dbo_ASample.Value.TrendNdx)Like "276") And ([dbo_ASample.Value].[Date] Between [forms]![frmBldgAanimals]![txtStartDate] And [forms]![frmBldgAanimals]![txtEndDate]));

This is not working ??? I am trying to compile the data by an average value, min value,and max value. Grouping the data by the day. ultimately i need to have the data for the last 7 days.

Your Help is Appreciated AND HAPPY VALENTINE'S DAY