Grouping, Not Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a report of a shot list for a film schedule. At the moment, it looks
something like this:

Shot 1, Scene 1, Int. Hallway, Long Shot Man
Shot 2, Scene 1, Int. Hallway, Long Shot Man
Shot 3, Scene 2, Int. Hallway, Close-Up Man
Shot 4, Scene 2, Int. Kitchen, Midshot Man

However, what I would like is for the locations and scenes to be grouped,
while only sorting by the shot sequence. I don't want to sort by location or
scene, just group. As in:

Int. Hallway
- Scene 1
Shot 1...
Shot 2...
- Scene 2
Shot 3...

Int. Kitchen
- Scene 2
Shot 4...

Am I overlooking a really obvious way of doing this?
 
It looks like your report should be sorted and grouped by:
Location with Header
Scene with Header
Shot

Am I overlooking something obvious?

Duane Hookom
MS Access MVP
 
Thanks for responding Duane.

My problem is that something like this:

Shot 1, Scene 1, Int. Hallway, Long Shot Man
Shot 2, Scene 1, Int. Hallway, Long Shot Man
Shot 3, Scene 2, Int. Kitchen, Midshot Man
Shot 4, Scene 2, Int. Hallway, Close-Up Man

will end up breaking the shot order and look like this:

Int. Hallway
- Scene 1
Shot 1...
Shot 2...
-Scene 2
Shot 4

Int. Kitchen
- Scene 2
Shot 3...
 
Yeah, I figured it out. I knew it was something easy I was overlooking.

Just sort by:
Shot
Location (Header)
Scene (Header)

And make the headers not visible if they're repeated.
 
Back
Top