sort prob from query to report

[_Bigred]

access 2000

i have a query of data it sortsdescending 2004
2003 etc....


But the report I have based on this query, lists it in the opposite
direction 2003

2004 etc...

How do i fix this issue,
TIA
_Bigred

 

[Guest]

-In report design view, select Sorting and Grouping from the view menu
-Select the field you want to sort your report by, and the type of sort
-save the changes to your report.

 

[_Bigred]

worked like a charm.

Thanks,
_Bigred

-In report design view, select Sorting and Grouping from the view menu
-Select the field you want to sort your report by, and the type of sort
-save the changes to your report.