Grouping Of Data

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 Replies


ADVERTISEMENT

Grouping Data

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

Data Grouping

Jan 14, 2008

Hi, Last piece of advice i got from here was excellent so thought i would try it again,

I have records that show delivery days and postcodes some post codes have more than 1 item going to them on several days through the week i was wondering if i could group the same postcodes together so it only showed 1 record instead of a possible 15 but only those delivered on the same day, Is this possible?

View 3 Replies View Related

Grouping Daily Data By Week

Nov 2, 2005

Hi all,

I currently have a table that holds 2 months of data. Let's just use January/February 2004 as an example.

The field name is [DateReceived] and goes from '1/1/2004' to '2/29/2004'. I need to group my records in 7-day spans for a future query, so anything from 1/1 to 1/7 would be grouped, etc.....

I have no idea how to do this. Any help would be great.

sanctos

View 2 Replies View Related

Grouping: Data Access Pages

Dec 18, 2007

G'day,

Putting together some data access pages to display data from tables.

All is good except a property that I do not like, when there are multiple records in the returned recordset from the query to the page, I have grouped these by ID (for example).

Each time you move to next record the display contracts back to just the top level of display, that is with the the ID number displayed in a text box and a "+" to expand it out to see the details of the record under that group.

I would like have it always expanded to show the details of the records as I scroll though the ID numbers (the top level of grouping), rather than having to expand for each ID number to see the details.

Not sure that is clear, but any ideas..........

View 1 Replies View Related

Grouping Two Tables Which Have Different Number Of Data

Sep 23, 2007

Hi All,
I have two tables

Table A

EmpID EmpName
001 Will
002 Jack
003 Emma
004 Greg

Table B
EmpName EmpHobby
Will Sport
Jack Reading

I wanna join the two table by using query so the result will be

EmpID EmpName EmpHobby
001 Will Sport
002 Jack Reading
003 Emma (blank)
004 Greg (blank)

what query should I write

Kindly need your help,i am frustrating with this

View 2 Replies View Related

DLookUp, Dates And Grouping Data

Jun 10, 2007

Hello!

Is it possible to group data in form from table within two dates with aggregate function DLookUp,

Thanx

View 1 Replies View Related

Forms :: Grouping Data Within Combo Box

Aug 15, 2013

I have a list of customers, with Account Numbers and Company Names. Now I have entered a combo box in my form control with a list of Account Numbers, how ever I wish to group these Account Numbers because some are the same, with the same company but a different Employee.

So how do I group Account Numbers within the combo box?

View 4 Replies View Related

Grouping Data Into Sections From A Field?

Oct 10, 2014

I have a database with a list of clients. One field is for their date of birth.

I have to report on equality and need to know how many clients we have within the following age groups:

16 - 24
25 - 34

35 - 44
45 - 54
55 - 64
65+

I have looked through the group and sort functions and cannot see anything obvious.

View 2 Replies View Related

General :: Grouping Data To Send To Email

Jul 11, 2012

i have a filter that shows the bookings for the weekend, which i can click on each act and it generates an email for then to confirm. however some acts have more than one booking on that weekend and i want to be able to list the bookings in one email, the email script i use at the moment is below, the acts can be grouped by a field called grouped

Code:
Private Sub artist_DblClick(Cancel As Integer)
Dim msgTxt As Variant
Dim objOutlook As Outlook.Application
Dim objMailItem As Outlook.MailItem

[code]....

View 1 Replies View Related

Queries :: Grouping Data By Week And Display

Mar 19, 2013

I am trying to create a query that will group my data by each week so I can sum up some numbers and display them on a per-week basis... Prefer the week to start on Sunday but really not picky about it.

Using the following in the query design window.

Week of Year: Format([Date],"ww")

This is returning:
1
10
11
12
2
3
4
and so on.. See the problem?

I tried sorting but that doesn't work.

I also tried the following:

Format([Date],"mmmm,ww")

But this is returning
December,51
December,52
February,8
February,9
January,1
January,2
January,3

Yes, there are some weeks without data but that's not the problem. The issue is that its putting February before January.. Why is this? Again, I tried sorting options and several other techniques but no success.

View 5 Replies View Related

Reports :: Grouping Report Data From Start To End Date?

May 31, 2014

Grouping a report data starting from date 01.04.2013 to 31.03.2014 ??

View 2 Replies View Related

Reports :: Group Data In A Report From Single Table Using Grouping And Sorting

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

Queries :: Pull Data Values In Array To Become Grouping Headers In A Report

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

Grouping

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

Grouping

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

Grouping

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

Grouping

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

Grouping %age

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

Grouping

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

Grouping Objects

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

Change Grouping

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

Grouping Time

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

Grouping Numbers

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

Grouping With Particular Records At The Top

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

Grouping Many Different Dates

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







Copyrights 2005-15 www.BigResource.com, All rights reserved