Kamis, 15 September 2011

RE: [MS_AccessPros] Sorting and Grouping on a Report

Art,
Why is your primary sort using RoomCountName and not the field called SortOrder with A on top?

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Thu, 15 Sep 2011 12:53:04 -0700
Subject: 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.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]


[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar