Order in query is lost in report

[Jon Geiger]

I have a subreport which is based on a query. When I run the query it
delivers the fields ordered by date descending, as requested. When I run the
(sub)report, all fields are delivered but in date ascending. Any clues or do
I need to post more specifics?
Thank you,
Jon

 

[SteveM]

Use Sorting & Grouping in your report at design time. There is a button on
your menu bar that will present you with a dialog similar to setting indexes
on a table.

Steve

 

[Jon Geiger]

Ah-ha! Thank you very much.
Jon

Use Sorting & Grouping in your report at design time. There is a button on
your menu bar that will present you with a dialog similar to setting indexes
on a table.

Steve

 

[Pat Hartman]

and don't forget to remove the sorting from your query. There is no point
in sorting the recordset twice.