Decending Date

[Guest]

I am using Access 2003
I created a report. In a query I put in the criteria (for a date field) to
be decending.
When I press run - the data shows just like I want it, but when I run the
report the date field is not in decending order. Does anyone have any idea
as to why this is and how I can correct it. This date field is the second to
be sorted in a particular order. Would this have anything to do with it?

Aurora

 

[Larry Linson]

I am using Access 2003
I created a report. In a query I put in the criteria
(for a date field) to be decending.
When I press run - the data shows just like I want it, but when I run the
report the date field is not in decending order. Does anyone have any idea
as to why this is and how I can correct it.

Why it is: The reason is that the order of the data in the Report's Record
Source is immaterial to the ordering and grouping of data in the Report.

To Correct It: In Design View of the Report, right-click the upper-leftmost
little box, and choose Sorting and Grouping. That, the Report's Sorting and
Grouping is what determines the order and grouping of data in the Report. It
is not version-specific.

One Other Thing: Because it doesn't affect the display of data in the
Report, you might as well remove the Sort specifications from the Query and
save a little processing time.

Larry Linson
Microsoft Access MVP