Reports :: Combination Of Grouping And Sorting In Report Does Not Work
May 15, 2013
Access 2010. I have a table with the following fields:
- From
- To
- TypeOfWork (to be chosen from a combo-box)
- Activity (text field to be filled in freely)
In a table i have a complete day with times (from -> to), the type of work between those times and the activity performed between those times a bit like this:
FROM TO TYPE OF WORK ACTIVITY
00:00 - 11:00 Welding Welding clamps
11:00 - 13:00 Welding Welding anodes
13:00 - 15:00 Cleaning Cleaning pipes
15:00 - 18:00 Cleaning Cleaning floor
I would like it to show in the report like this:
FROM.....TO.......TYPE OF WORK.....ACTIVITY
00:00 - 13:00......Welding............00:00 Welding clamps
...............................................11: 00 Welding anodes
13:00 - 18:00......Cleaning...........13:00 Cleaning pipes
...............................................15: 00 Cleaning floor
So it should sort on "From", then group by "TypeofWork" and repeat the "From" field(I think...). But I now have tried every combination of sorting and grouping I could think of and nothing works!
View Replies
ADVERTISEMENT
Dec 2, 2014
I'm trying to group data in a report from single table using grouping and sorting and I want the percentile of every record over group total. I'm using a query to fetch data from table, however I'm unable to get percentage of every single record over group total.
I want to display the report as attached image in single report. I'm unable to get data in "Perc" field. It's populating wrong values.
View 3 Replies
View Related
Feb 20, 2015
I have 3 fields Yes/No.
A B C
To be in order it is necessary that: A , B and C = Yes.
I would want to print all different combinations :
A = no et B et C = Yes
Then
A: Missing
Nom, prenom et adresse.
.....
.....
A = Yes, B=No and C = No
Then
B and C missing :
Nom, prenom et adresse.
......
.......
Etc.....
View 1 Replies
View Related
Feb 23, 2006
Ok Second issue: I have a list of companies that each offer 5 different programs. Eash Listing in the query (My report is built on this) has both a column for the definition and a colum with a number idenitfying the amount of people in the program.
What I need is to HIRE someone, but maybe I can do this:
I want to list each company and all 5 programs associated with that company; easy and its done.
Then I want to have a summary at the bottom of the report that goes to each company, takes the 5 programs for maybe 1, maybe 3 or maybe 92 companies, and lists them in order. Order = the top 5 programs for all the different companies. See and it gets complicated because sometimes, a program can be the largest for every company in the report, and then the second program for each company is different for each each company. So I need to arrange the programs in an order. then sort them by size, and them only show the top 5.
PLEASE, if you got through this far of my irrational and illogical brain then maybe you can help
Thanks Sean
View 2 Replies
View Related
Apr 10, 2015
What I wish to achieve is to create a report that groups and sorts without the need of a header section as it is taking up to much space cascading :
----
----
----
----
----
----
rather than :
---- ---- ---- ----
----
----
---- ---- ----
----
----
I basically want it not to cascade but do the exact same thing as it does inside its own header. (We need to dramatically cut down the page amount as a delivery schedule is printed out daily and could do with the page count around 10 rather than 50 ).
(Links below)
What It Looks Like ....
What I Want ....
View 2 Replies
View Related
Feb 2, 2015
How can I change report Sorting and Grouping through code? I tried:
Dim rpt As Report
Dim strReportName As String
strReportName = "ReportName"
[Code].....
But this did not work. I assume because it is on the Open command for the report. I think I might have to place some Event Procedure in the Group Header - On Format or On Print? However, I can not find the right syntax to do that.
View 1 Replies
View Related
Jul 13, 2015
I have a table for gathering interview scores for candidates from multiple reviewers (example below)
Field1 - RankID
Field2 - Presentation Score
Field3 - Writing Score
Field4 - Applicant Name
etc.
Each applicant will be interviewed by multiple reviewers. I want a report to display the data is grouped by Applicant name, but sorted by Score.
Applicant2 - average presentationscore = 5
Applicant1 - average presentationscore = 4
Applicant3 - average presentationscore 2
it seems simple enough to group by applicant name and sort by PresentationScore, but this does not work. I have used the grouping and sorting feature in every combination I can think of and it always keeps the Applicant Names in order whether I group first on PresentationScore (which will then give me several entries for same applicant) or not. What am I missing?
View 6 Replies
View Related
Mar 2, 2013
I am trying to create a report grouped by payment date. The problem I'm having is there are 3 different payment date fields on one table and 1 payment date field on another table. I cannot figure out how to get my group expression to pull up the dates from each one of the fields. Do I need to create a new table for each payment type, or is there a way to create a common field "Payment Date" and pull up date from these 3 fields. I have a criteria form which sets beginning and ending dates, but where to assign it. The report is called "Payments by Date" and I need to show PPD (primary payment date), SPD (secondary payment date), etc.
View 1 Replies
View Related
Nov 8, 2014
I'm trying to create a report with data from 7 different tables. It's supposed to be an assignment overview for a transfer company (driving people from A to B, dunno how to call it in English). I put assignment and customer details into the page header, which is working out fine so far. But now I want to show transfer details and it's proving to be a bit troublesome.
When creating the assignment, the user can choose whether the transfer goes from/to an address or from/to an airport. Depending on which one he chose the data is stored in different tables. To determine whether it is an outward journey/collection, outward journey/target, return journey/collection or return journey/target, I put a field in each of those tables ("Schritt", its value being either 1, 2, 3 or 4).
To visualize I made screenshot of the tables in relationship view, but since I'm a new member i can't seem to post images, so I'm giving you a pseudo URL...
[abload (dot) de (slash) img (slash) transeren40p1r.png]
The final report should look like this:
outward journey
---collection (1)
---target (2)
return journey
---collection (3)
---target (4)
Having the "Schritt" value for each step in either one or another table (address(es) or flight data) is making it a bit hard for me to wrap my head around the problem. Is that doable with expressions or is there a way in VBA to solve this problem?
View 7 Replies
View Related
May 31, 2014
Grouping a report data starting from date 01.04.2013 to 31.03.2014 ??
View 2 Replies
View Related
Jul 27, 2014
I have a query where I ORDER BY ClientId, MatterId and Transdate. The result of the query is correct. All of the transdates are in ASC order within the Matter.
When I run the report for a MatterId the relative transactions are not sorted on transdate
Can there be something in the report that could be effecting the order of the transactions.
View 3 Replies
View Related
Jul 27, 2006
I have a query that is sorted on the officename and the lastname.
My report is grouped by officename
I can't get the lastnames to be sorted alphabetically - I'm not sure why, since they are in the query.
What can I do to make it grouped by officename and lastname sorted?
View 1 Replies
View Related
Dec 23, 2004
I have a report that sums the failure cost and displays it in weekly increments. The Query that populates this report brings in [Date], [failure cost], and [department]. I need to separate one department out of the total and display it's total separately on the same report. I am using the [Date] field to group it into weekly increments. Any help would be greatly appreciated.
View 3 Replies
View Related
Jul 1, 2013
I'm trying to make a report that a untrained user can use to review the relevant data from the database I'm creating. All of the work I've done so far has been directly in the tables . Here's a quick outline of my general data organization:
Department:
DepartmentID(PK)
DepartmentName
Employee:
EmployeeID(PK)
EmployeeName
DepartmentID(FK)
Needs_Work (check box)
[code]....
Basically, I want the user to select a department to view using a combo box or option group (which I'm not sure of how to do in a report). Then, I want to view the employees within that department sorted first by whether or not the Needs_Work check box is selected, and then by how many of their competencies are unchecked.
View 2 Replies
View Related
Oct 27, 2013
I have a query that has a field that reads DateReceived By Month: Format$([Workorders].[DateReceived],'mmmm yyyy') The criteria line is Like "*" & [Enter Month & Year (Leave Blank for all)] & "*" And this works when I run the query. If I enter october 2013 it shows only records for this date range like it should.
Then I built a bar chart report that will show the workorders only for the month entered. The problem is, If I leave this field in my query the chart does not update . When I open the chart it will prompt for the month and year but the data in the bar chart doesnt change. If I remove this field the chart updates as expected.
If I go into design view for the report and then right click on the chart and go to properties , then to row source, it reads as this:
TRANSFORM Sum([Workorders Query2].MyTime) AS SumOfMyTime SELECT [Workorders Query2].SerialNumber FROM [Workorders Query2] GROUP BY [Workorders Query2].SerialNumber PIVOT [Workorders Query2].[MXDPrinter];
If I click on the elipstical to go into query tools for this line , and click on run I get the error : The microsoft Access database engine does not recognize '[Enter Month & Year (Leave Blank for All)]' as a valid field name or expression.
So my criteria runs normally in the query and returns the correct records, but I can't get it to work in the chart .
View 1 Replies
View Related
Nov 27, 2014
I am using the student database template and I have added some tables and made some changes so I am trying to get all of the existing reports to work. The Emergency Contact Report is giving me an invalid sorting and grouping error. I have never even used a report and I have no clue what needs to be fixed.
View 1 Replies
View Related
Apr 1, 2015
I have date picker which works correctly in form. When I put that form as subform to reports header calendar shows up but after selecting date on calendar textbox stays blank. Format of textbox is Short Date, Show date picker property is For dates.
View 1 Replies
View Related
Nov 3, 2004
I have a report with set up as follows:
Group Header: Division
Group Header: Subdivision
Detail
Is it possible to get the Division to only appear once per value?
e.g.,
Division
Subdivision
Detail
Subdivision
Detail
NEW Division
Subdivision
Detail
etc.
Right now the Division appears before the subdivision every time, even if the division is the same as before. I did change "Hide Duplicates" to "yes", but that didn't help.
View 3 Replies
View Related
Aug 19, 2004
Hello,
This is a bit of a stupid problem but I've been trying to get a report in Access that will display data in a certain format but have been having real difficultly getting the grouping right.
This is the SQL query that I've got which gets all the results
SELECT Student.Surname, Student.Forename, Student.Admission_No, Student.Year, Course.Course_Title, Student_Course.Grade, Student_Course.Points, Student_TotalPoints.Total_Points, Student_TotalPoints.Mean_Points, SchoolTotal.School_Total FROM ((SchoolTotal INNER JOIN Student ON SchoolTotal.Year=Student.Year) INNER JOIN (Course INNER JOIN Student_Course ON Course.Course_Id=Student_Course.Course_id) ON Student.Student_id=Student_Course.Student_id) INNER JOIN Student_TotalPoints ON Student_Course.Student_id=Student_TotalPoints.Stud ent_id;
See attachment for results this produces...
I would like to get these results to be displayed like this:
Name Admission No Year Course Grade Points
Dave Jones 1856 2004 Business D 60
RE C 80
-------------------------
Total Points 140
Mean Points 70
--------------------------
Becky Smith 1974 2004 Chemistry A 120
Physics B 100
---------------------------
Total Points 220
Mean Points 110
---------------------------
etc
I know I could do this for a webpage using ASP so there must be somewhere to get the report looking like this in Access....
Any help would be much appreciated...
Andy
View 1 Replies
View Related
Jan 26, 2014
I have a report showing products and their selling prices
Most products have only one selling price, however a few have more than one selling price
To cater for this I have created a group called "Products"
The selling prices are then in the reports' "details" section.
Works well, except that every product now spans 2 lines. One for the product description and another for the price. This doubles the number of pages in the report.
As products with only one price is the norm, is there a method that I can adopt to show products:
* with one selling price - product description and selling price on one line
* with more than one selling price - product description and first selling price on one line, with subsequent selling prices on line below?
View 1 Replies
View Related
May 30, 2013
I have a report that has a group within a group. The interior group has a footer with a textbox calculating an average. I would like the Outer group to then SUM the averages. I tried doing a =sum([TextBoxWithTheGroup Average]), but access prompts me for the value of this box when I run the report.
To summarize: is there a way to sum a textbox within the footer of a grouping
View 1 Replies
View Related
Nov 2, 2013
Placing the grouping total values on the bottom of the last page of this report, such as below?
Common . . . . . . 44.55%
Convertable Bond .14.55 %
Preferred . . . . . . .40.91%
View 1 Replies
View Related
Feb 6, 2015
I have a table which now contains a couple of hundred records with more than thirty fields each, and will ultimately contain over 1000 records. Some of these fields use the multiple value feature, and the fields and the forms which fill them work beautifully. Now comes the challenge.
Without going into detail that I'm not at liberty to share, I can say that there are different offices which have different people who are responsible in different ways for the work covered in these records. It is possible for each record to have multiple people assigned to it from the same office. This requires setting the control that shows the people from each office to allow multiple values. I need to be able to create a report which will allow me to hand a list of all the records each person is responsible for in the office to the person responsible, in spite of the fact that this will mean records will show up on more than one person's report.
Before I knew that there might be multiple people in the office for each record, I created great reports grouping and ordering by this office's control and field. Now, since they allow and store multiple values, I can't use them any more. I need to be able, as I said above, to get the same effect. I think the answer lies in some sort of calculated field or formula that applies text filters. What I need to be able to do is look in the field for this office and see if a person's name is contained in the field for that particular record, regardless of who else might be in the field, too. I need to be able to use the results from this filter or calculation or formula to generate something I can use in the group and order by processes.
View 7 Replies
View Related
Mar 13, 2015
In reports, we can sort items, A to Z or Z to A.
Is there any option we could apply another sort list customized to different criteria ?
For Example, first display B, then A then C ?
View 1 Replies
View Related
Jan 5, 2006
Hi everyone,
I have a field in a table on Access 2000 database with takes the following information in any order and can be repeated. e.g. can have 10, etc people with contact signed, 10, etc people with PDD issued, etc.
contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.
I am designing a report in which I want to Group and order the info. in the field in the order shown above, e.g 1. contract signed, then 2. PIN issued followed by PDD issued, etc in Ascending order say and the other way round say CER's issued, EB approved, etc.
Can anyone help here? I have not much experience with designing reports but I have tried using the report Sorting and Grouping and it does it in aphabetical order, not in that order I require.
Thank you
dfuas
View 10 Replies
View Related
Nov 14, 2004
Hi,
I have a problem with the output of a report , i have a couple of tables and
one table here like u can see in this relationship diagram is 'DRA' (attached file) which i want to display the combined results of table 'R' and table 'DO' in the report,although i get the reults into the report of these 3tables starting from --> DRA then table 'R' results followed by the results of table 'DO' , now the problem is its displaying , i would like the display to be like that in the 4th column (as u can see in the pic) , i have tried a lot in the reports but i cant seem to get this output , i would really appreciate the help...
Thank you,
solig.
View 4 Replies
View Related
