Are all of the Station IDs grouped together as shown in your example? For instance would NEW ever be located in more than one section of the report?
If the Station IDs are always together, you could create a totals query that groups by Station ID and includes the Minimum of the Seq. Add this to the report's record source and set the primary sorting/grouping on the Min of Seq. and then sort of Seq.
Duane Hookom
MS Access MVP
To: accessdevelopers@yahoogroups.com
From: atkinson_joe@hotmail.com
Date: Sat, 18 Aug 2012 22:50:00 -0500
Subject: RE: [AccessDevelopers] Question on report sorting/grouping
If the Station IDs are always together, you could create a totals query that groups by Station ID and includes the Minimum of the Seq. Add this to the report's record source and set the primary sorting/grouping on the Min of Seq. and then sort of Seq.
Duane Hookom
MS Access MVP
To: accessdevelopers@yahoogroups.com
From: atkinson_joe@hotmail.com
Date: Sat, 18 Aug 2012 22:50:00 -0500
Subject: RE: [AccessDevelopers] Question on report sorting/grouping
No problem Duane. In case the formatting is lost, I need the report to be sorted by Seq value (4-9 in the records below), and would like a dashed line printed whenever the Station ID ("STU", "NEW", "IOW" below) changes.
To: accessdevelopers@yahoogroups.com
From: duanehookom@hotmail.com
Date: Sat, 18 Aug 2012 21:35:56 -0500
Subject: RE: [AccessDevelopers] Question on report sorting/grouping
Track Seq Car LE Block To Station KD W Z B Commodity BOL
...
4 TTZX 857087 L WAUSAU STU STUART STUART FB FORMS CONC
-------------------------------------------------------------------------------
5 HS 89231 LL RAMP NEW NEWTON NEWTON P 2 C/TOFC
6 HS 903126 LL RAMP NEW NEWTON NEWTON P 2 C/TOFC
-------------------------------------------------------------------------------
7 ARMN 765183 E MILLARD IOW IOWACIT IOWACIT R **EMPTY**
8 HLTX 7209 L ALPLA IOW IOWACIT IOWACIT C PLASTIC
9 CIC 2075 E CIC IOW IOWACIT IOWACIT C **EMPTY**
-------------------------------------------------------------------------------
...Thanks very much for your willingness to have a look.
Joe
To: accessdevelopers@yahoogroups.com
From: duanehookom@hotmail.com
Date: Sat, 18 Aug 2012 21:35:56 -0500
Subject: RE: [AccessDevelopers] Question on report sorting/grouping
I don't typically open any attached files so I have no clue how you actually want to sort and/or group. Could you type some sample records into a reply with the dashed lines in the appropriate location?
Duane Hookom
MS Access MVP
To: accessdevelopers@yahoogroups.com
From: atkinson_joe@hotmail.com
Date: Fri, 17 Aug 2012 16:28:43 -0500
Subject: [AccessDevelopers] Question on report sorting/grouping [1 Attachment]
Duane Hookom
MS Access MVP
To: accessdevelopers@yahoogroups.com
From: atkinson_joe@hotmail.com
Date: Fri, 17 Aug 2012 16:28:43 -0500
Subject: [AccessDevelopers] Question on report sorting/grouping [1 Attachment]
[Attachment(s) from Joe Atkinson included below]
I'm attempting to create a report based on the sample seen in my attachment. Without getting into VB code, is there a way to generate the dashed lines whenever the Station ID (e.g. "STU", "NEW", "IOW") changes, while still keeping the records in order by the Seq value? I've tried to do so via grouping, but if Seq is first in the sort/group order, the dashed lines appear between every record, and if it's second or non-existent, the report correctly groups the Station IDs, but it rearranges everything into Station ID order.
Thanks very much for your assistance.
Joe
__._,_.___
Please zip all files prior to uploading to Files section.
.
__,_._,___
Tidak ada komentar:
Posting Komentar