[DKTaber]

Have a continuous Access 2000 subform that contains a date field (LtrDate). The subform is in an input form. I want the subform to sort its records in descending order by that date field. It doesn't. Some records ARE in the correct decending order, but only by coincidence. The question is why?

I have

• entered in the Orderby property of the subform "LtrDate DESC"
• sorted the table which is the control source in DESC order by LtrDate and saved
• opened the form, clicked the LtrDate field, and clicked the Z-A sort button on the toolbar

Nothing produces the right sort order in the subform.

What's wrong?

[MustBNuts]

I have a similar setup for a system I built quite a few years ago: Main form is Company information (name, address, tel, etc.), subform is a history of activity (date, memo field). I have this loading in date order, most recent first.

What I did to create this was to build the subform around its own query for the data source. The table for this subform only has three fields (co name, date, history), the query sorts first by company, then by date (so that as you are scrolling through the main form and land on a specific company, it is linked to its appropriate history and will populate in reverse date order).

Hope this helps,

MBN

[DKTaber]

MustBNuts: Thanks. I have done the same thing many times (using a sorted query as the data source). In this case, I don't need a query because have nothing special I want to do with the table data... except sort it. I still can't understand why Access ignores the OrderBy property. But since it does, I guess I'll have to do it thru a query.

[DKTaber]

MustBNuts: Just to close the loop, I created a query sorted in descending order by LtrDate, and (of course) the form now displays the records in that order. Still bewildered by Access ignoring the OrderBy property.

[Chris_E]

I've just created a subreport, based on an underlying query.

Regardless of the sort order I set within that query (I want it to sort by Date (Ascending), when presented within the main report, the data in the subreport is not sorted by date, rather by the primary key of the query (which do I want to show but not as the focus of the sort).

If I run the query in isolation of the form, the results are shown in sorted order and if I just run the subform up, its also sorted ok, but never when I look at the subform within its main form.

I use the same query for the data entry subform as the reports subreport and it works fine for the form, but not the report!

Do SubReport sorts behave differently to SubForm sorts?

Can someone suggest where I should look to address this?

Thanks

Chris

[Chris_E]

Argh!

Just spotted the "Sorting and Grouping" facility for Reports.

Why is this tucked away and why cant the query just do it on its own for goodnes sake!

Closed!

Chris

[OBP]

Microsoft