How to sort my detail records in a report?

[sueb]

I have a pretty simple report that prints a master record, then the detail records. In spite of my query sorting on first the master record and then the detail record, my detail records are coming out in what looks to me to be totally random order. (They are, at least, appearing under the correct master record, and the master records are in the correct order.)

I've uploaded both the back and front ends, if anyone would be good enough to look at it. (So far, there's just the one report.)

Thanks!

[jimatqsi]

Reports don't sort based on the query. You specify the sort order within the report because you also have to specify if you want break headings and footers. On the toolbox toolbar there is a tool for Sorting and Grouping.

Jim

[sueb]

Thanks, jimatqsi! I thought there must be something like that, but just kept overlooking it.

[TheSmileyCoder]

Minor correction:
If you have NOT specified a Sort or grouping, the report will sort in the same way as the underlying query.

[sueb]

TheSmileyOne, I thought that's what I'd originally done, but now I'm not so sure. I'm going to go back and fiddle with that--thanks!