Sorting NOT Working

[Guest]

I have a main report with a subreport in it. For each record in my main
report i have a group of records in my sub report. I'm trying to sort my
records in each sub report under my main report and it doesn't sort at all. I
tried ascend and desc and neither works. I'm sorting on a date field in the
subrecords. When i run it the records are mixed together and no sorting is
taking place.

Can anybody help!?

 

[Ken Snell \(MVP\)]

Use Sorting & Grouping in the report for the sorting. Reports usually ignore
the ORDER BY clause in the record source's query.

 

[Marshall Barton]

I have a main report with a subreport in it. For each record in my main
report i have a group of records in my sub report. I'm trying to sort my
records in each sub report under my main report and it doesn't sort at all. I
tried ascend and desc and neither works. I'm sorting on a date field in the
subrecords. When i run it the records are mixed together and no sorting is
taking place.

Typical reasons for that are:

A) You failed to specify the sorting in the (sub)report's
Sorting and Grouping window. This overrides any sorting
specified in the report's record source table/query.

B) The date is really in a text field, which will be sorted
as a string of characters instead of as a date.