My report is not alphabetizing during the sort.

[DMF]

I have the query set up to sort in increasing order, I have the report to
sort in increasing order, but when the report is processed the item is
grouped by names but the names are not alphabetical. What am I missing

 

[Al Campagna]

DMF,
Are you using the Sorting & Grouping dialog box to control your report
sorting?
If so, please provide a bit more description of what you want to do, and
your S&G entries.
(ex. This is what I have now... vs. this is what I want to see.)
S & G is what controls sorting in reports... not the RecordSource
table/query.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John Spencer MVP]

Use the Report's sorting and grouping to set up sorting for a report. Menu:
View: Sorting and Grouping).

Reports ignore the query's sorting. Often the records get returned and
processed in the order of the query, but there is no guarantee that will happen.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[KARL DEWEY]

grouped by names but the names are not alphabetical.
This is contradictory. Post example of what you mean.