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