Hello All,
I have a question about sorting in a report. Right now I have multiple reports sorting off of my companies table that has two fields; CompaniesID, and Company Name. Well the problem I am running into is that I constantly add new companies into this table and the CompaniesID is an auto number that currently all the reports are sorting off of, what I want to be able to do is sort by Company name in a report rather then CompanyID, but every time I try it doesn’t show the company at all, shows the CompaniesID not the Name, or puts everything together under the first company and doesn’t show everything else. I have other tables that are linked off of the CompaniesID, I am using the auto number because it was recommended to me, but there has to be a way to sort from the Company Name with out having to renumber all the companies every time I have to add one.
Thank You,
Sean
8  1749  NeoPa 32,556
Expert Mod 16PB
There is indeed fairly full support for this in Access reports. Look at Sorting and Grouping within your report.
Let us know how you get on :)
i can only sort by CompaniesID because that is whats linked to the companies table. then in the report i have the companiesId in a combo box with a width of 0".
NeoPa 32,556
Expert Mod 16PB
Well, I'm working blind as you haven't shared much information, but why can you not sort on any field that is in the query? The facility is there.
the field isn't in the query, only companiesID is. here is how my tables are set up:
tblAll:
EmployeeID - PK - Auto Number
Company- FK
Name
Job Title
Id Color - FK -
Date ID Issued
Date ID Expired
Date Started Work
tblCompanies:
CompanieID - PK - Autonumber
Company Name
tblIDtype:
IDTypeID - PK - AutoNumber
ID Type
Why not just create a query that includes more than one table? This would allow you to use the company name field in sorting and grouping. I added a link to an article detailing how to write SQL for multi-table queries. SQL Joins NeoPa 32,556
Expert Mod 16PB
Light is beginning to dawn :)
I would not even have considered adding that info via a ComboBox, but now I understand what you're trying to do I would agree that JKing's solution is ideal for you.
Let us know how you get on with that.
That helped a lot thank you, sorry for such the long response time, i had been gone for awhile, but that worked great. thank you again.
NeoPa 32,556
Expert Mod 16PB
No problem, I'm glad we were able to throw some light on the matter for you.
Well done JKing (Excellent choice of link BTW ;))
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Hohn Upshew |
last post by:
I need some help to build a report enumerating the products in
descending order depending on the sum of liters.
In this way i can view the top products sold for a given period.But i
fail to do...
|
by: Grim Reaper |
last post by:
I know this is probably an easy question, but I could not find/figure it
out.
Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together....
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have...
|
by: James P. |
last post by:
Hello,
I have a report with the Priority field is used as sort order and
grouping. The problem is the data in this Priority field if sorted in
ascending order is: High, Low, and Medium. How...
|
by: Mike MacSween |
last post by:
tblCourses one to many to tblEvents.
A course may have an intro workshop (a type of event), a mid course
workshop, a final exam. Or any combination. Or something different in the
future.
At...
|
by: Mike |
last post by:
Hello All,
I have a report based upon a query. I have added a control to report
footer that calcs the total cost of the inventory: =SUM().
When this total calculation is NOT on the report,...
|
by: manning_news |
last post by:
I've got a report that's not sorting correctly. I build a SQL
statement and assign it to the recordsource in the Open event, sorting
the data the way the user chooses. The user can choose up to 3...
|
by: ApexData |
last post by:
I have one table used to maintain information on Service Events.
Each record contains a Repair, Maint, and Battery checkbox
(bound/boolean). Any one of these fields may be checked or left empty....
|
by: Jana |
last post by:
Hi!
I have an Access 97 report based on tables linked to an SQL back end.
The report has 5 subreports in it (unfortunately unavoidable due to the
nature of the report) and performance is quite...
|
by: sara |
last post by:
Hi -
I have looked at all posts and tried both Allen Browne's Report
Sorting at run Time
( Select Case Forms!frmChooseSort!grpSort
Case 1 'Name
Me.GroupLevel(0).ControlSource = "LastName"...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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...
| |
