List report chronological

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I have a report constructed to show group name in the
header section and then show the times the group meets in
the detail section. This causes the listing to list in
alphabetical order instead of chronological order. Is
there a way to list this in chronological order without
repeating the group name every time the meet time is
listed?
TIA
George
 
Maybe you could type or paste in some sample records with field names and
how you would like them to appear. I am somewhat lost since you seem to want
two different sort orders in the same report.
 
Currently I come up with a list like this:

ABC Company
10:00AM-11:30AM
1:00 PM-2:00PM
XYZ Company
8:00AM-10:00AM

with this type of grouping the cronological order is
incorrect. When I try to sort by time it gives me
something like:

8:00AM-10:00AM
XYZ Company
10:00AM-11:30AM
ABC Company
1:00 PM-2:00PM
ABC Company

What I would like it to look like in cronological order is:

XYZ Company
8:00AM-10:00AM
ABC Company
10:00AM-11:30AM
1:00 PM-2:00PM

Is there a way to do this?
Thank you for your assistance...
George
 
You could create a query that groups by Company and selects the
Min(StartTime). Add this to your report's record source so that you could
sort by:
MinofStartTime
Company
StartTime
 
Back
Top