Sorting and Grouping (1 Viewer)

[skydiver]

Access 2003. I have a report that spits out data pertaining to boats. The report displays vessel name, sailing date, sailing time along with other data. In my sorting and grouping fields, I have the following:

Date - Ascending (Group header, grouped on month)
VesselName - Ascending ( Group header & footer, grouped on each value)
Date - Ascending (grouped on each value)
SailingTime - Ascending (grouped on each value)
Date - Ascending (grouped on each value)

At this point, I can't remember why I have the third Date field with the same parameters as the previous date field. My problem is I would like the report to sort in the following order:

1. Date (by month)
2. VesselName
3. Date (each value)
4. Sailing Time (from earliest to latest)

I get everything sorted correctly, except my sailing time. The times are scattered, therefore the data is scattered. Please help!

 

[Brianwarnock]

I would love to help but I don't know what your report data or code look like, but my instinct is to ask why 3 and 4 aren't combined.

Brian

 

[skydiver]

How can I combine 3 & 4?

 

[gaby]

DateTime Stamp

 

[skydiver]

Is there a "quick fix" I can do within the report itself?