473,569 Members | 2,705 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Grouping and Sorting a report or form, Please Help

2 New Member
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 7442
NeoPa
32,564 Recognized Expert Moderator MVP
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

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

Similar topics

1
12770
by: El_Embozador | last post by:
Hi , please can you tell how i can print an MS ACCESS Report form visual basic, i ned a sample code .. Thanks
2
1892
by: PC Datasheet | last post by:
Does anyone have a technique for grouping in a form like grouping in a report and still be able to enter data in the form? Thanks for all responses, Steve PC Datasheet
1
2379
by: Peter | last post by:
Dear all, Could you give me a hint? a) I generate a report from a query table, then I want to use this report to show the total numbers of the customers who buy the goods. There is a string field "choose goods" in the table. Such field only contains either "1" or "". Therefore, I write the IIF function on the report form at the...
1
1225
by: Samuel | last post by:
Why my Crystal Report form works on the machine I installed VB.NET, not works on the machine without VB.NET? Thanks.
0
1336
by: neeraj | last post by:
Hi people's I developed One Windows application with some crystal Report I used my predefined crystal reports files for my application. I just take one crystal report viewer on form and set report source = location of my crystal report file. The version of crystal report software is 8.0 When I execute my application and open report from...
5
1200
by: allystone99 | last post by:
Hi, Sorry to be a numpty! I'm pretty new to Access and there are a lot of things I haven't figured out yet. I'm using Access 97. I don't know anything about code or VB! Basically, I want a form where I'm able to select a particular date or location etc from combo boxes, and for it to show me the corresponding revenue and profit from a query...
12
2136
by: Sol | last post by:
Hi gurus, I work for an oil company and need to fix an old DB, which used to work once. It will help us poor operators to do a safer job. What it does: When maintenance on a vessel is planned, the vessel needs to be isolated from the rest of the process. For this, "Blinds" are being inserted between the vessel and the rest of the process. ...
1
1650
by: kkshansid | last post by:
i have some crystal reports but no related forms i made new simple form and copy pasted contents of a crystal report form to this new form and changed Dim Report As New CrystalReport6 according to my crystal report name but its not working.plz help ..........
1
2413
by: Deepak Wadhwa | last post by:
how to make report with help of D2k in oracle?
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7673
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7970
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6284
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5513
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5219
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1213
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.