Need to delete parameter in report--can't find it!

[evansc]

I have a query that asks for the start date and end date in order to generate the results. I have a report built off of it.

I changed the name of the fields so that there are no spaces. The query still runs correctly. However, when I try to open the report, I get asked for the start date, the end date, and the start date again. I assume is is somehow still looking for the original start date--the one with the space. I have checked the sorting and grouping and the fields on the report, but I can't find where it might be. Does anyone know where else to look?
Here's the sql for the query. It works fine when I run it as a query. But when I run the report it asks for an additional parameter--as if there's a field there is can't identify. But I don't get any errors on the report or anything--if I just press enter for the last parameter it works fine. It's just confusing for people.

SELECT Courses.CrsTitle, Courses.Location, Courses.OfficeStaff, Courses.Registrar, Courses.PgrmMngr, Courses.StartDate, Courses.EndDate, Courses.StartDate AS [Start as Date only], Courses.EndDate AS [End as Date only], Courses.StartDate AS [Start as Day only], Courses.EndDate AS [End as Day only], Invitees.InviteesAbbr, Invitees.Invitees
FROM Invitees INNER JOIN Courses ON Invitees.Invitees = Courses.Invitees
GROUP BY Courses.CrsTitle, Courses.Location, Courses.OfficeStaff, Courses.Registrar, Courses.PgrmMngr, Courses.StartDate, Courses.EndDate, Courses.StartDate, Courses.EndDate, Courses.StartDate, Courses.EndDate, Invitees.InviteesAbbr, Invitees.Invitees
HAVING (((Courses.StartDate) Between [Enter Start Date] And [Enter End Date]))
ORDER BY Courses.StartDate;

 

[dhookom]

If the query runs fine then it isn't much help showing us the SQL. Check the control sources again, especially in the headers and footers.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.