Problems with summarising data in a parameter query

[Guest_imported]

Please help!!

I am having problems with a paramter query I have created. The query correctly prompts for a start and end date. What then happens is that it displays total costs information and the number of records (using the count function) for each individual record over that time period.

What I want to happen is that it just displays the total costs and number of records for all the records within the time period specified - in effect 1 record or row of summary information.

Any ideas would be gratefully received!

Rgds, LL

P.S. don't know if this helps, but here is the SQL for the query:

SELECT ESS_tbl.[Won, Pending or Lost], ESS_tbl.Date, Sum(ESS_tbl.[Estimate Value]) AS [SumOfEstimate Value], Count(ESS_tbl.[Won, Pending or Lost]) AS [CountOfWon, Pending or Lost]
FROM ESS_tbl
GROUP BY ESS_tbl.[Won, Pending or Lost], ESS_tbl.Date
HAVING (((ESS_tbl.[Won, Pending or Lost])="won&quot AND ((ESS_tbl.Date) Like "??/??/?0" And (ESS_tbl.Date) Between [Please enter start date] And [Please enter end date]));

 

[JimHorton]

Lozza,
Remove the date from the 'group by' clause, it should be a 'where' clause only, from what you say. If you want to show the dates, then use the *identical* parameters in an 'expression' , and the date range will show ie:
"Range " & [Please enter start date] & " to " & [Please enter end date] AS Expr1
--Jim

 

[Guest_imported]

Brilliant - you've solved my problem. I never knew 'where' existed so I shall have to research it.

Thanks a million Jim!