I am using a query that, apart from showing other info, has a date column. I have set the date column in the query to show in ascending order... all is well. I use the same query in a form and it shows the dates in the order I set in the query, but in the report it shows the date in descending order. Why is this? I would have though the date order in the report would be as per the query.

I hope someone has the answer to this.

Dave

Which version of Access are you using,

You can set multiple levels of sorting in your report unlike Queries and Forms, so something might have looked a another field.

Open the report in Design View and if using 2003 then look at the View menu and select sorting & Grouping select the field you want and sort

Open the report in Design View if using 2007 then look at the bottom and sorting and groupings are located there.