Order of appearance in report

  • Thread starter Thread starter Jan F Jonsson
  • Start date Start date
J

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?
 
This is probably the order you inserted records in... Set the order on your
reports recordsource...

HTH

Tom.
 
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?
 
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>
 
Back
Top