ordering by date in a subreport

D

Debbie S.

I have subform which also functions as a subreport in one of my reports. Both
the subform and the subreport have three fields: action, taken by, date. In
the subform, I can order the actions by the date simply by placing my cursor
in the date field and right clicking on sort ascending. Now, when I go to any
record in the subform, the actions are all in the correct order by date,
ascending. However, when I go into the report in which I have put the subform
as a subreport, the dates do not list in order. The sorting and grouping in
the report applies only to the main report, not the subreport; and I don't
see any place to be put an order by clause. Does anyone know:

1) Why the dates would be out of order in the subreport even though they are
in order in the subform (same data, from the same query).

2) How to make the dates in the subreport appear in order

Thank you,
Debbie
 
M

Marshall Barton

Debbie said:
I have subform which also functions as a subreport in one of my reports. Both
the subform and the subreport have three fields: action, taken by, date. In
the subform, I can order the actions by the date simply by placing my cursor
in the date field and right clicking on sort ascending. Now, when I go to any
record in the subform, the actions are all in the correct order by date,
ascending. However, when I go into the report in which I have put the subform
as a subreport, the dates do not list in order. The sorting and grouping in
the report applies only to the main report, not the subreport; and I don't
see any place to be put an order by clause. Does anyone know:

1) Why the dates would be out of order in the subreport even though they are
in order in the subform (same data, from the same query).

2) How to make the dates in the subreport appear in order


The form's (temporary) sorting is not carried over. I
recommend that you use a real report for the subreport
instead of using a form as a subreport.

Sorting and grouping is the only reliable way to sort a
report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top