471,862 Members | 1,737 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,862 software developers and data experts.

Grouping and Sorting a report or form, Please Help

I've tried this on both a report and form and have had no luck.
I have 7 fields and am trying to group my form by 'Part Number' and then sort by 'Date Added' I have multiple of the same part
number (intentionally). Right now I have the 'Part Number' grouped together and my form/reports are sorted by 'Date Added' date first.
However, my problem is that I have to also sort by 'Part Number' using ascending or descending (it won't group my 'Part Number' together if I don't put ascending/descending). SO my form after running the query displays the 'Part Number' in groups, but it's not starting with the newest date added.

MY GOAL: Find a way to first put each part number into groups and then sort those groups by date with the newest 'Date Added' appearing first.

Thank you for your time

NOTE: As of right now if I remove the sort by, or if I move the 'Part Number' after the 'Date Added' field. Then the 'Part Number' column is not grouped together regardless of whether I have 'group by' selected.
Nov 18 '21 #1
1 7180
32,462 Expert Mod 16PB
Hi there - and welcome to Bytes.com.

Strangely enough, because most things that work for Forms work similarly for Reports, Sorting & Grouping is something that's quite different between the two.

In a Report the Group & Sort option is accessed from the Report Design toolbar. Simple enough I would expect. Let us know if you have any problems there.

In a Form the sorting (No grouping as such in Forms.) is managed first of all by the RecordSource but if there is an OrderBy property set then that will take precedence.

Again, hopefully, now you have that the rest should be straightforward. Obviously though, if you do struggle then come back and give a clear explanation of what you struggle with so we can help further.
Nov 18 '21 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by El_Embozador | last post: by
2 posts views Thread by PC Datasheet | last post: by
1 post views Thread by Peter | last post: by
reply views Thread by neeraj | last post: by
5 posts views Thread by allystone99 | last post: by
1 post views Thread by Deepak Wadhwa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.