I am trying to implement a report based on an ordered query. The query has 3 ordered fields (Date, Time and Location in that order). When I look at the result of the query, everyting is properly ordered. If I print the report whithout any grouping (ie as it is), the result is OK. However when I tried to group it by date, the grouping by date is correct but the time and location are completeley out or sequence. What I want to do is separate dates so the report is easy to read maintaining the ordered time and location as creatd by the query. Any help is very much appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping the report based on an ordered query
- Thread starter regava
- Start date
- Thread starter
- #3
Don't waste your time attempting to sort the record source (query) of a report.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question