The status date depicts what position on the waiting list they are. Oldest at the top (person who has been waiting the longest.
I have sent a snapshot of the report to the Needs Assistance folder which might help with understanding what I am after.
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Thursday, September 15, 2011 2:36 PM
Subject: RE: [MS_AccessPros] Sorting and Grouping on a Report
Art,Are you aware that you can have multiple sorting and groupin levels in a report? I would think StatusDate is a bit granular for any grouping but it's your data and we can't see it.Duane HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Thu, 15 Sep 2011 17:46:19 +0000Subject: [MS_AccessPros] Sorting and Grouping on a Report I ran into a bit of a dilemma with a report. This is the query behind the report:SELECT qryApplicantExtended.ApplicantID, qryApplicantExtended.[Applicant Name], tlkpRoomCount.RoomCountName, tlkpApplicationStatusType.ApplicationStatusTypeName, tblApplicationStatus.StatusDate, tlkpRoomCount.SortOrderFROM (qryApplicantExtended INNER JOIN (((tblApplication INNER JOIN tblApplicationReview ON tblApplication.ApplicationID = tblApplicationReview.ApplicationID) INNER JOIN tblApplicationStatus ON tblApplication.ApplicationID = tblApplicationStatus.ApplicationID) INNER JOIN
tlkpApplicationStatusType ON tblApplicationStatus.ApplicationStatusTypeID = tlkpApplicationStatusType.ApplicationStatusTypeID) ON qryApplicantExtended.ApplicantID = tblApplication.ApplicantID) INNER JOIN tlkpRoomCount ON tblApplicationReview.RoomCountID = tlkpRoomCount.RoomCountIDWHERE (((tblApplicationStatus.ApplicationStatusTypeID)=3))ORDER BY tlkpRoomCount.SortOrder;On my report I have it grouped by the RoomCountName which breaks up the report starting with the RoomCountName = "Five". I added a field called SortOrder to tlkpRoomCount so the table looks like this:RoomCountID RoomCountName SortOrder1 Five 62 Four 53 One 14 One or two 25 Pending 76 Three 47 Two 38 None (Denied) 8but the issue is I needed the report sorted by oldest StatusDate first which this does right now but I want the grouping in the correct order so its grouped like One, One or Two, Two, etc. basic by the SortOrder field.Any ideas?Art LorenziniSioux Falls, SD
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar