Report not in right order

[Guest]

I have a report to print a song list that is based on a query. The query is
sorted in ascending fashion on the artists name. If I view the query, the
order is correct (artist name, song name, song writer, song key). If I create
a report using this query and only display this artist name field, the report
is in the correct order, by artist name. If I add any other field (song name,
writer,key) to the report, then the order is no longer correct. It starts
displaying based on the auto number ID field for the artist's name, instead
of the name. I used the report wizard to create the report. I don't
understand what's is causing this. Could somebody clear this up for me?
Thanks,
RandyM

 

[SusanV]

You can set the order via the report properties, data tab, Order By - be
sure to also set Order By On to Yes.

 

[Phil Hunt]

The report has a "Sort/Group by" property which can override the Query order
by.
Try open the report and take a look at the items availble on the tool bar.

 

[fredg]

I have a report to print a song list that is based on a query. The query is
sorted in ascending fashion on the artists name. If I view the query, the
order is correct (artist name, song name, song writer, song key). If I create
a report using this query and only display this artist name field, the report
is in the correct order, by artist name. If I add any other field (song name,
writer,key) to the report, then the order is no longer correct. It starts
displaying based on the auto number ID field for the artist's name, instead
of the name. I used the report wizard to create the report. I don't
understand what's is causing this. Could somebody clear this up for me?
Thanks,
RandyM

Any sort order in the query is irrelevant to the sort order in a
report.
To set the sort order in a report, use the report's Sorting and
Grouping dialog.
In Report Design View click on
View + Sorting and Grouping