Field sorting problem

[Steve]

Hi,

I have a query that returns data sorted on 2 fields. Name and then
RequestDate.

When I put this into a report the Name field is sorted ascending but the
RequestDate field is sorted randomly.
How can I fix it to be sorted the same as the query?
Thanks,

 

[Duane Hookom]

Sorting in a report relies on the sorting set in the report's Sorting and
Grouping dialog.

 

[Steve]

That was it.
Thank you.

Sorting in a report relies on the sorting set in the report's Sorting and
Grouping dialog.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm