Trying to get a sub-report to open sorted by ItemN

I have a form that has a sub-form.  I have been able to make the sub-form sort the records in descending order by setting OrderBy = [ItemN] in the Form Data properties.

But I have a report opening from a command button on the form and the details in the sub-report WILL NOT sort in the proper order even though the record source for the sub-report is a query with the field ItemN set to descending.

??
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Reports handle sorting much differently, and will ignore the sorting set in a query. Instead, add a Sort to your report in Design view. The Grouping and Sorting box is shown at the bottom of the Design window. If you don't see it, click the "Group & Sort" item in the Grouping & Totals ribbon item.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.