Form and Report based on same query however ID shows up differntly

[jj1]

My problem is I have a query on which my form and report is based. I have made my ID in query as Ascending However it shows up jumbled in report and Ascending in form. I want it to be ascending at both places

[ranman256]

Reports sort independent of query.
In the report , use grouping/sorting to sort the way you want.

[jj1]

Where to find this property
In the report , use grouping/sorting to sort the way you want.