I would like to create a report where the user can enter the sort order via a Form. I'm a novice here. I have eight topic areas, I wanted to allow the user to enter the order, so that the report generates in that order.
Topic A = 4
Topic B = 2
Topic C = 1
Topic D= 7
Topic E = 8
Of course, the sort order of the report would be 1, 2, 3, 4, ...8. Then the user can change the numbering so that they can change the order of the report.
I see instructions for using sortorder: switch and iif, in the query but I want the user to be able to change the number of the sort.
Thanks for your help.
Topic A = 4
Topic B = 2
Topic C = 1
Topic D= 7
Topic E = 8
Of course, the sort order of the report would be 1, 2, 3, 4, ...8. Then the user can change the numbering so that they can change the order of the report.
I see instructions for using sortorder: switch and iif, in the query but I want the user to be able to change the number of the sort.
Thanks for your help.