Problem solved. Please ignore this.
Set the sort order in the report - under the Group & Sort option, Design menu.
Thank you, aytee111. It worked... using the same convention as used in the query. You have advanced my knowledge of reports in Access. Thanks again, Jim
Forum Rules