Hi Guys,

Can anyone spot why my query is givine me a SYNTAX error? I'm new to sql so I'm not sure what the problem is.

TIA

PARAMETERS [Input Date] DateTime;
SELECT [tblTSR Sales Verification].[Sale Date]
FROM [tblTSR Sales Verification]
WHERE ((([tblTSR Sales Verification].[Sale Date])>=[Input Date] And ([tblTSR Sales Verification].[Sale Date])<[Input
Date]+1))
SELECT DISTINCTROW [tblTSR Sales Verification].[First Name], [tblTSR Sales Verification].[Last Name], [tblTSR Sales Verification].[Client Site Name], [tblTSR Sales Verification].[Client ID], Format$([tblTSR Sales Verification].[Sale Date],'Long Date') AS [Sale Date By Day], [tblTSR Sales Verification].[Sale Position], [tblTSR Sales Verification].[Call ID], [tblTSR Sales Verification].[Phone 1], [tblTSR Sales Verification].[Phone 2], [tblTSR Sales Verification].[Product Name], [tblTSR Sales Verification].Parnter, [tblTSR Sales Verification].[Agent ID], [tblTSR Sales Verification].[Agent Name], [tblTSR Sales Verification].Status, [tblTSR Sales Verification].CommentCode, [tblTSR Sales Verification].Comment, Count(*) AS [Count Of tblTSR Sales Verification]
FROM [tblTSR Sales Verification]
GROUP BY [tblTSR Sales Verification].[First Name], [tblTSR Sales Verification].[Last Name], [tblTSR Sales Verification].[Client Site Name], [tblTSR Sales Verification].[Client ID], Format$([tblTSR Sales Verification].[Sale Date],'Long Date'), [tblTSR Sales Verification].[Sale Position], [tblTSR Sales Verification].[Call ID], [tblTSR Sales Verification].[Phone 1], [tblTSR Sales Verification].[Phone 2], [tblTSR Sales Verification].[Product Name], [tblTSR Sales Verification].Parnter, [tblTSR Sales Verification].[Agent ID], [tblTSR Sales Verification].[Agent Name], [tblTSR Sales Verification].Status, [tblTSR Sales Verification].CommentCode, [tblTSR Sales Verification].Comment
HAVING (((Format$([tblTSR Sales Verification].[Sale Date],'Long Date'))>=[Input Date] And (Format$([tblTSR Sales Verification].[Sale Date],'Long Date'))<[Input Date]+1));