469,612 Members | 1,602 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,612 developers. It's quick & easy.

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.
2 Weeks Ago #1
1 6200
NeoPa
32,200 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.
1 Week Ago #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 devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.