Unbound control changes sorting of data

[John McAtee]

I am using Access 2007. Created a contribution database for a non-profit. Created parameter query that displays contributions for a specified time period using the "Between [Beginning] And [End]" parameter. The query sorts by company then last name. Created a report that uses the query as the data source. Displays data per the query. When I put an unbound control in the Report Footer or Header to count the number of contributions the names get sorted by First Name. The same happens if I delete the count and add an unbound control to sum up the contributions. If I delete the unbound controls then the sort goes back to Last Name. Can not find the problem. Created the report twice with the same effect.

[NeoPa]

Do you have Sorting and Grouping set in this report?

[John McAtee]

Do you have Sorting and Grouping set in this report?

No. I do not need any grouping and I did the sort in the query. adding that unbound control in the footer changes the sort from Last name to First name

[NeoPa]

You need to set your sorting up in the report under Sorting and Grouping.

That's your problem then. You need to set the sorting in the report as otherwise it will make it's own mind up as to which sort order suits it best.

[John McAtee]

That's your problem then. You need to set the sorting in the report as otherwise it will make it's own mind up as to which sort order suits it best.

That indeed was the problem. Thank you.

[NeoPa]

A pleasure John :)