Reversing dates for Reports

[Guest]

I have a report of comments on particular topics. The report looks at the
comments related to a particular topic
Private Sub Command10Preview_Comments_Click()
On Error GoTo Err_Command10Preview_Comments_Click

Dim stDocName As String

stDocName = "Topic Comments"
DoCmd.OpenReport stDocName, acPreview, , "[TID]=" & Me![Topics2.TopicsID]
so even though the report is based on a a comprehensive query of all
comments, the report will only look at those comments related to a specific
topic. I would like this report to display in reverse chronological order,
and changing the sort in the comprehensive query does not do it. Can you
assist?
Thanks!

 

[Steve]

If you want to sort in a report, you need to do it in sorting and grouping
in the report.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Of Course! I have done this but just didn't remember! Thanks!

If you want to sort in a report, you need to do it in sorting and grouping
in the report.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I have a report of comments on particular topics. The report looks at the
comments related to a particular topic
Private Sub Command10Preview_Comments_Click()
On Error GoTo Err_Command10Preview_Comments_Click

Dim stDocName As String

stDocName = "Topic Comments"
DoCmd.OpenReport stDocName, acPreview, , "[TID]=" &
Me![Topics2.TopicsID]
so even though the report is based on a a comprehensive query of all
comments, the report will only look at those comments related to a
specific
topic. I would like this report to display in reverse chronological
order,
and changing the sort in the comprehensive query does not do it. Can you
assist?
Thanks!