sorting problem

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

Guest

I have a report that runs from a query. In the query there is a date field.
It is set for ascending order. When I run the query itself the dates are
listed correctly in ascending order. But when the report is run, the dates
do not list in ascending order. Am I missing? This is occuring in more then
one report. Below is a simple query in which it is not occuring on the
report but does in the query.

SELECT ClientName, ClientServicesPerson, OverallClientStatus,
ClientRenewalDate
FROM usrtblClientInformation
WHERE (((OverallClientStatus)="Active") AND ((ClientRenewalDate) Between
[Forms]![usrfrmReportModule]![txtStartDate] And
[Forms]![usrfrmReportModule]![txtEndDate]))
ORDER BY ClientRenewalDate;

Thanks in advance for anyone who responds.
*** John
 
Sorting in a report is reliably set in the Sorting and Grouping dialog in
report design view. Sorting of the report's record source query has little
or no affect on the report printing order.
 
Hi John
In the report you need to sort your data using the sorting and grouping
dialog box(In the menu bar select View > Sorting and grouping) , in there
select the field you want to sort by and the order type.
 
Ofer and Duane, thanks for the info. That did it. A person does so much but
knows so little. As in my case.
Thanks again.
*** John


Ofer said:
Hi John
In the report you need to sort your data using the sorting and grouping
dialog box(In the menu bar select View > Sorting and grouping) , in there
select the field you want to sort by and the order type.

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



JohnE said:
I have a report that runs from a query. In the query there is a date field.
It is set for ascending order. When I run the query itself the dates are
listed correctly in ascending order. But when the report is run, the dates
do not list in ascending order. Am I missing? This is occuring in more then
one report. Below is a simple query in which it is not occuring on the
report but does in the query.

SELECT ClientName, ClientServicesPerson, OverallClientStatus,
ClientRenewalDate
FROM usrtblClientInformation
WHERE (((OverallClientStatus)="Active") AND ((ClientRenewalDate) Between
[Forms]![usrfrmReportModule]![txtStartDate] And
[Forms]![usrfrmReportModule]![txtEndDate]))
ORDER BY ClientRenewalDate;

Thanks in advance for anyone who responds.
*** John
Click to expand...
Click to expand...
 
Back
Top