Report is not in proper order

[EFox]

Hello!

I have a query that I am using to pull transactions from a table. In the query I sort by transaction ID in ascending order. When I run the query the datasheet view looks perfect, sorted by transaction ID. However, when I run my report it no longer uses the sort that was created by the query (transaction ID) and it looks to be sorting by the unit ID field instead. I do not have it set anywhere to sort by unit ID, but I am curious if there is something on my report that is causing this.

The report itself has no filter, filter on load is set to NO, order by is set to nothing, order by on load is set to NO, and Allow filters is set to YES. Where else can I look to see if something is trying to be sorted on the report?

Not sure if it matters but this is an Access 2013 front end and a SQL 2008 back end. Thanks in advance for any ideas or suggestions.

EFox

 

[vbaInet]

1. What is the Record Source of the report?
2. Do you have a Grouping in place in the report?

 

[EFox]

As soon as you asked about the grouping on the form I thought back to when the form was created and it probably set a default sort by to the unit ID (which is the first field in the group. I right clicked on the transaction ID and enabled sorting on that and everything works great!

Sorry for the total idiot moment, but I guess talking out loud helps!

Thanks for the reply vbaInet. It made me think about what was set on initial wizard creation that I for some reason never thought to look at that.

 

[vbaInet]

Sorry for the total idiot moment, but I guess talking out loud helps!

It sure does!