Sorting gets inverted

[sales@scantechintl.com]

Hi,
I have a form/subform for Orders & Order Details.

The Order Details has a auto numbering / primary key called [IDItem].

In the underlying query of the report, I specify that [Idtem] sorted in ascending (Chronological) sequence but on the report they come up in reverse sequence i.e. last entered - first printed.

What am I doing wrong?

 

[statsman]

Hi,
I have a form/subform for Orders & Order Details.

The Order Details has a auto numbering / primary key called [IDItem].

In the underlying query of the report, I specify that [Idtem] sorted in ascending (Chronological) sequence but on the report they come up in reverse sequence i.e. last entered - first printed.

What am I doing wrong?

You may have to set the sort order in the report as well.

 

[sales@scantechintl.com]

Your right. I reset the sort fields and it works.
Thank you.