Report asking for parameters

[MeldrethMan]

I have a simple report based on this query

PARAMETERS [Enter Start Date] DateTime;
SELECT tblAllContacts.FirstName, tblAllContacts.Surname, tblAllContacts.[Record Created]
FROM tblAllContacts
WHERE (((tblAllContacts.[Record Created])>=[Enter Start Date]) AND ((tblAllContacts.Volunteer)=Yes))
ORDER BY tblAllContacts.Surname;

On creating the report this appears in Order By and reappears even if deleted and the report saved.

[tblAllContacts].[Staff], [tblAllContacts].[Surname], [tblAllContacts].[StaffID], [tblAllContacts].[ContactID]

When running the report it asks for these four parameters. Why?
I don't get these requests when just running the query. In case there's something lurking in the report I've tried creating a totally new one but the same happens.

 

[dhookom]

I have never experienced something deleted from the Order By reappearing after the report has been saved.

I would open the report in design view, delete the Order By property values, check the sorting and grouping, and then save the report.

Duane
Hook'D on Access
MS Access MVP

 

[MeldrethMan]

Thanks Duane. I've found that somehow there was an Advanced Filter set, can't imagine where that came from.

Now just need to remove a header. On clicking Group An Expression the Area group isn't in the list and it's this I want to remove now.

How do I kill it? This is probably a dumb question, sorry.

 

[MeldrethMan]

As an addition to this last post, when creating a new report based on the same query the Order By entry appears again and the Advanced Filter is automatically being set requesting the four fields Staff, Surname, StaffID and ContactID. What's causing this?

 

[dhookom]

Do you have something in your table or query design that is carrying over to the Record Source and properties?

Do you have any of the autocorrect options turned on?

Duane
Hook'D on Access
MS Access MVP