Grouping and Sorting a report or form, Please Help

[tbutler]

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.

[NeoPa]

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.