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