• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 26
  • Last Modified:

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.

??
0
SteveL13
Asked:
SteveL13
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now