Grouping Problems In Report.
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 Replies
ADVERTISEMENT
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
Dec 8, 2007
Hi everyone, I am having a lot of trouble doing something that is probably very simple.
My scenario is customers order products, lots of products, now i need to know the quantities of these products for all my customers. It doesnt have to be by customer name, all i need is the product and the Quantities.
I can produce a Report that contains what i need in it but i would like to summarise it.
My report now has the PRODUCT and the QUANTITY for each product that was entered in the order, Problem is the Same product comes up all the time in the report.
For example Product= Tray Lasagne Quantity = 1
Product= Tray Lasagne Quantity = 2
etc...
And it has a continues list in the report, i would like to group the products so that it shows like this on the report:
Product=Tray Lasagne Quanity= 1, 2 etc
Is this possible? Thanks.
View 13 Replies
View Related
Dec 27, 2006
First of all, we have a database for all company customer cases (through out the whole year of 2006). Every case has its own priority level.
‘Priority’ column has three option, ‘High’, ‘Medium’, and ‘Low’.
We are new to Access, and we are trying group all the case month to month (group them by their created date) on separate pages. At the end of each monthly summary, we’d like to do a number count on ‘High’, ‘Medium’, and ‘Low’.
Here is a sample that we are trying to get to…
Sample Datebase,
Case #// Created Date// Priority Level
001 12/5/06 High
002 12/7/06 Low
003 12/3/06 High
004 12/1/06 Medium
005 11/9/06 Medium
Sample Report we are trying to get to...
Summary for December:
Case #// Created Date// Priority Level
001 12/5/06 High
002 12/7/06 Low
003 12/3/06 High
004 12/1/06 Medium
Total Case: 4
High Priority Case: 2
Medium Priority Case: 1
Low Priority Case: 1
your help will be very appreciated! :rolleyes:
View 1 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
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 13 Replies
View Related
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
Apr 23, 2014
I have a table with application records. One of the fields captures schools the applicant will work at. This field stores data in comma delimited format. There could be 1 school name; there could be 5 school names.
My ultimate goal is to build a report which shows me records of all applications, grouped by school choice. I want to see: School A was selected by 5 people, School B was selected by 7, etc.
Is it possible to write a query from this table that will enable this?
View 4 Replies
View Related
May 2, 2006
I have created an invoicing system for a CD shop
There is a transaction table which has each individual cd sold as a seperate transaction. Each transaction has an order number, so there can be more then one cd sold per order, but they all still have their own record in the table.
im now invoicing each order by mail merge based on a query that finds all the details on every transaction but wht ive found is that the mail merge puts each transaction onto a different page even if its from the same order number as another.
does anyone know how to group each order in the query so that all the items in one order come in a single invoice?
View 3 Replies
View Related
Jun 21, 2005
Hi, I have a query which numerous fields, and I need to make a report based on the query. However I need to group 3 fields in the query and press the sum button on 2 of them, Qty and Total Price (which is qty*price)
I need to do this so in the report when a particular wine is purchased more than once, instead of repeating the peoples name who bought the wine, it will only show 1 and automatically add the rest to the total price.
I dont know how to group within a query, can someome please tell me how? Thanks.
View 1 Replies
View Related
Jul 6, 2005
Hi to all;
I have one code of 6 digits; each digit refer to a group; first 2= product group; beverage; live animals,….itc (24 product groups), the 3ed digits= food product, the 4th-6th digit= detail product group; vegetables, fruits,….,the rest of digits refers to product name, carrot, apple,…itc , example 070511
How can I use the query to sum the product value at different group level; example the first 2= product group, ..?
Do I have to split my code to 6 cods to do my calculation?
Thank in advance for help
majed
View 1 Replies
View Related
May 2, 2006
I have created an invoicing system for a CD shop
There is a transaction table which has each individual cd sold as a seperate transaction. Each transaction has an order number, so there can be more then one cd sold per order, but they all still have their own record in the table.
im now invoicing each order by mail merge based on a query that finds all the details on every transaction but wht ive found is that the mail merge puts each transaction onto a different page even if its from the same order number as another.
does anyone know how to group each order in the query so that all the items in one order come in a single invoice?
View 7 Replies
View Related
Sep 21, 2004
Hi all
I am trying to find a way of finding the number of a group of sessions as a percentage figure. e.g. total number of clients attending 1-3 sessions = 20%, 4-6 =15%, 7-12 =21% 1-2years = 8%, etc. and entering this calculation in a report.hope you can help.
Dave
View 9 Replies
View Related
Jul 18, 2005
Question on grouping within Access Reports:
A simplistic view of the report I'm trying to generate is as such:
Company Name - Company Description - Employee
I am grouping by Company name, and I am hiding duplicates of Company Description because they can be long. I also have the Company Description as Allowing to Grow.
The problem is that the first record gives the company, the description, and the employee name on the first line just fine, but the second employee name won't be listed until the Company description ends. When the description is about a paragraph long, the other employees look very seperated from the initial record.
Any way to fix this?
View 1 Replies
View Related
Mar 9, 2008
Hi,
can form objects be grouped? i currently have numerous buttons on a form that are shown according to a button selection. my current code makes all buttons visible / invisible singularly but i wiondered if they could be grouped/ named and the get the code to make the group visible / invisible?
many thanks,
NS
View 4 Replies
View Related
Sep 19, 2005
Can you help me.
I have about 2000 records with Part Number XXXCOGxxxxx. This Should be C0G. Ex:
SPN
RPE122COG101K
RPE122COG681K
RPE122COG101K
RPE122COG681K
GRM40COG100J
GRM40COG100K
GRM40COG101J
GRM40COG150J
GRM40COG220J
GRM40COG221J
GRM40COG271J
GRM40COG470J
GRM40COG471J
GRM42-6 COG100J
GRM42-6COG220J
GRM42-6COG472J
What to write a query to change just the COG portion. Can you tell me the formula?
Thanks
Chris
View 1 Replies
View Related
Oct 23, 2005
I am trying to group time entries so that I can say, between 8AM and 10AM there were this number of calls. I have a field called Time_Assigned with numberous time entries (such as 08:15:33 AM) corresponding to another field called Incident_Type (such as medical). The data spans a whole year so I have several thousand time entries and I would like to show how many incident types occur between such and such hours. Thanks again for everyone's generous help.
View 2 Replies
View Related
Dec 6, 2005
Hi,
I would like to know how i can group numbers into bands.
e.g
Col 1
1
2
3
4
5
6
How do I group the above into groups of i.e. 1 - 3 and 4 - 6, or group in regular intervals like 1-2, 3-4, 5-6?
Regards
View 3 Replies
View Related
Feb 24, 2006
Hi all,
I have a db for logging meeting action points. Each action point has a description and owner. I'd like a query/report which will produce a list of action points grouped by owner (easy), but with a particular owner's action points at the top.
Essentially, rather than do a GroupBy and ascending sort, i need to specify the first group that is displayed. I don't care in what order the other groups appear.
Eg.
Action Point Owner
1. Task 1 DC
6. Task 6 DC
8. Task 8 DC
3. Task 3 AG
4. Task 4 AG
So, above if i just did an ascending sort, the DC records wouldn't be at the top.
any ideas?
El.
View 3 Replies
View Related
May 16, 2006
How do i group the following records
ID Surname Pack
29679Minican 1
29679Minican 2
27818Oliver 1
27818Oliver 2
27818Oliver 3
so its will show ...
27818Oliver
29679Minican
... on a spreadsheet
View 1 Replies
View Related
Jul 6, 2006
I have a table which stores meeting room booking information in half hour slots.
If someone books a 2 hour meeting then 4 records would be produced – one for each half hour. I want to produce a query which will group the data by room (ScheduleID) showing the max and min times (ie the initial start time and final end time) for each event and the event details. The table structure is as follows
ScheduleDetailsID, ScheduleID, CustomerID, ScheduleStartTime, ScheduleEndTime, meeting purpose
And the query I have tried is as follows:
SELECT [Schedule Details].ScheduleDetailsID, [Schedule Details].ScheduleID, [Schedule Details].CustomerID, Min([Schedule Details].ScheduleStartTime) AS MinOfScheduleStartTime, Max([Schedule Details].ScheduleEndTime) AS MaxOfScheduleEndTime, [Schedule Details].[meeting purpose]
FROM [Schedule Details]
GROUP BY [Schedule Details].ScheduleDetailsID, [Schedule Details].ScheduleID, [Schedule Details].CustomerID, [Schedule Details].[meeting purpose];
Can anyone tell me where I have gone wrong. It does not group the data as I want it to ie by room, then time, with only the initial start and final end times. Thanks in advance. Peter
View 3 Replies
View Related
Aug 1, 2006
I have a query which has many sums and counts on things like "Company name", "region name" and "Development Name".
I'm using this query for a report to do lots of percentages with, but now i need to filter this also by a date period.
So the user choses "Alex Homes" as the company name and then "July 2006" as the reporting month, and i need all the sums and counts to stay the same and only count/sum the records in the chosen month.
I can't seem to think of a way to do this.
If you need more info then ask.
View 4 Replies
View Related
Oct 10, 2006
I have a set of evaluation response data. There are a number of question (like 20), and each respondent answered the question on a scale of 1 to 5. Thus I have a table Responses where each column is a question and each row is a Respondent's answers. Each cell has a value between 1 and 5 (inclusive), or is possibly NULL.
What I want is to be able to list out the number of people who responded with a certain evaluation for each question. So it would list the number of people who gave a 1, a 2, a 3, and so on for each question. So I'd get something like:
---------Q1 Q2 Q3 Q4 Q5 ...
-1- x x x x x ...
-2- x x x x x ...
-3- x x x x x ...
-4- x x x x x ...
-5- x x x x x ...
Ideally I'd like the questions to be on the rows and the numbers as columns, but I can just do the transposition when I make this as a report.
Any ideas of a SQL Query that will get me such a table? I'd really like to avoid VBA if possible (I'm writing this database to be used/maintained by a non-programmer), and I'd like to not have to develop like 20 different subreports in order to print out this information.
Thanks.
View 6 Replies
View Related
Jan 8, 2007
I am having a problem that I hope has a very simple solution that I am somehow overlooking.
I have simplified my query for the purposes of this question. I have a query that only get the date and amount of a transaction. I want to group the information by date and have the transaction amount summed. For some reason it will not group by date.
Here is my query displayed in SQL:
SELECT Transactions.Date, Sum(Transactions.TransTotal) AS SumOfTransTotal
FROM Transactions
GROUP BY Transactions.Date
ORDER BY Transactions.Date;
And here is a sample of the data returned:
DateSumOfTransTotal
12/13/20055.12
12/13/20055.12
12/13/20055.12
12/13/20055.12
12/15/20051.15
12/15/20051
12/15/20050.12
12/15/20056.56
12/16/200519.14
12/16/200512
12/16/20058.16
12/17/200511.11
Why will it not group all the 12/13 or 12/15's together? I have done other queries like this and not had this problem. What am I overlooking?
Any help is very much appreciated. Thanks,
View 13 Replies
View Related
