Reversing dates for Reports

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

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!
 
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)
 
Of Course! I have done this but just didn't remember! Thanks!

Steve said:
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)



Cheese said:
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!
Click to expand...
Click to expand...
 
Back
Top