Report Not Sorting Correctly

[jsteff]

Created a simple query that is the basis for a simple report involving 9 joined tables. When you look at the SQL version of the query, it perfectly ends with "..ORDER by ID_NUM"

The report output looks great BUT it is not completely in ID_NUM sequence. Most of it is fine but a few of the ID_NUM records are out of order.

Any ideas?

 

[formerTexan]

Hi jsteff,

You may have the report's OrderBy property set. Also check the report's Sorting & Grouping properties as they will take precedence over any query level sorting.

Cheers,
Bill