Duane,
Thanks, I don't know why I was making it harder than it was. :)
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: Friday, September 16, 2011 10:33 AM
Subject: RE: [MS_AccessPros] Sorting and Grouping on a Report
Art,There is nothing that states the group by field must be the displayed field. You can sort/group by any field and display any other field in the group header and/or footer.Duane HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Fri, 16 Sep 2011 08:30:35 -0700Subject: Re: [MS_AccessPros] Sorting and Grouping on a Report Because I wanted the descriptive name to display for the group and not the a sort order number... Did I do that wrong?With warm regards,Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.comOffice: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-09471316 E. 7th Street Sioux Falls, SD 57103 SQL Server DevelopmentDatabase Adminstration ServicesMicrosoft Access Development Grant Writing TA ServicesIT Assessment ServicesSoftware Application Training From: Duane Hookom <duanehookom@hotmail.com>To: Access Professionals Yahoo Group
<ms_access_professionals@yahoogroups.com>Sent: Thursday, September 15, 2011 6:07 PMSubject: RE: [MS_AccessPros] Sorting and Grouping on a ReportArt,Why is your primary sort using RoomCountName and not the field called SortOrder with A on top?Duane HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Thu, 15 Sep 2011 12:53:04 -0700Subject: Re: [MS_AccessPros] Sorting and Grouping on a Report 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.comOffice: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-09471316 E. 7th Street Sioux Falls, SD 57103 SQL Server DevelopmentDatabase Adminstration ServicesMicrosoft Access Development Grant
Writing TA ServicesIT Assessment ServicesSoftware Application Training From: Duane Hookom <duanehookom@hotmail.com>To: Access Professionals YahooGroup <ms_access_professionals@yahoogroups.com>Sent: Thursday, September 15, 2011 2:36 PMSubject: RE: [MS_AccessPros] Sorting and Grouping on a ReportArt,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 JOINtlkpApplicationStatusType 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
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar