Order of appearance in report

[Jan F Jonsson]

I have a list with 20 items.
When a make a report the are shown in another order: 6-20 followed by 1-5.
Why is that? What can I do to fix this problem?

 

[tom]

This is probably the order you inserted records in... Set the order on your
reports recordsource...

HTH

Tom.

 

[Allen Browne]

Open the report in design view.

Open the Sorting and Grouping box (View menu).

Specify the field(s) you wish to sort by - one per line.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a list with 20 items.
When a make a report the are shown in another order: 6-20 followed by 1-5.
Why is that? What can I do to fix this problem?

 

[Jeff Boyce]

Jan

Reports sort/group independently of any sorting/grouping your query does.
In your report's design mode, select Sort/Group and set accordingly.

Good luck

Jeff Boyce
<Access MVP>