Sorting NOT Working

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!?
 
Use Sorting & Grouping in the report for the sorting. Reports usually ignore
the ORDER BY clause in the record source's query.
 
Adam said:
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.
Click to expand...


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.
 
Back
Top