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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ascending Sort in Report not working

Status
Not open for further replies.

Prufrock

Instructor
Sep 4, 2002
77
AU
Hi
I have a report based on a query. In the query I have a number of fields. One of these is an enrolment number and I have it set to sort ascending. Everything works fine. I then have a report that runs and it is based on the query. Whenever I run it I find the enrolment number are not sorted and yet it is the same query running.

Can any one assist?
 
Hi

Sort order in report is not depeandant the sort order of the underlying query, in report design view see view\sorting and grouping menu option

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Thanks Ken,

Spot On. I Appreciate Your Help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top