Ascending Order not complying

[skydiver]

Access 2003. I have a report based on a query. In the query, I have a date range criteria that is set to be in ascending order. Running the query gives me the date range in ascending order. Perfect! However, when running the report the dates are in descending order. In report design, I've ensured the sorting/grouping are also in ascending order, but no luck. Please help!

 

[vbaInet]

Are you sure that field's datatype is a DATE/TIME datatype?

 

[skydiver]

Are you sure that field's datatype is a DATE/TIME datatype?

Yes, the field's datatype is a DATE/TIME datatype.

 

[Brianwarnock]

I think that this is one of those only solved by seeing it.

Is it possible to remove the report sorting and grouping or is there grouping being done at reportlevel.

Brian

 

[boblarson]

Sorting in reports needs to be done within its Sorting and Grouping. Reports don't carry over sorting in queries.

 

[vbaInet]

Looks like the OP has already done that. It was hinted in the second to last sentence.

Like Brian said, looks like we might need to see it to understand what's going wrong.

 

[skydiver]

I redid report ensuring the date was in ascending order. It was like that before, but now it works. Go figure.

 

[vbaInet]

Corruption somewhere perhaps but good to hear that's sorted.

 

[Brianwarnock]

Sorting in reports needs to be done within its Sorting and Grouping. Reports don't carry over sorting in queries.

At what release did that happen?

Brian

 

[boblarson]

At what release did that happen?

Brian

Been there as long as there has been Access from what I remember. But I know for sure that Access 2000 and beyond has that requirement.

 

[Brianwarnock]

I have 2002 and if I have no sorting in the report it follows the sorting in the query, it would be weird if it didn't. What would it do , give a random order.


Brian

 

[boblarson]

I have 2002 and if I have no sorting in the report it follows the sorting in the query, it would be weird if it didn't. What would it do , give a random order.


Brian

It will put it in the order retrieved from the table. And so you might just be lucking out with the data being returned. Remember, that the table is not stored in any particular order (it will sort of attempt to order upon the PK field if there is one when a compact takes place, but any data added afterwards will not be ordered). So, your observations, just like many others, are seeing what appears to be standard behaviour but it is not. If you want to guarantee a proper sort in a report you must use the sorting and grouping.

 

[Brianwarnock]

It will put it in the order retrieved from the table. .

If the query says sort descending then it appears in the report in descending order, if ascending then in the report in ascending order, what has that to do with luck.

I accept and have always done my sorting in the report I had to do some changes to test this, but the op was sorting in the query and, I think, the report, I was just trying to help with the debug.

Brian