Minggu, 19 Agustus 2012

RE: [AccessDevelopers] Question on report sorting/grouping

 

Duane Hookom wrote:
> 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?

Station IDs would always be together.
 
> 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.

That sounds promising, but I'm brand new to Access, and I'm not sure I understand how to do what you're describing.  I've written a few queries, but all those to date just filter on a specific value or set of values.  Any additional details you'd care to add for the steps above would be gratefully received.

Thanks very much for taking the time to help!

Joe

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar