Multiple sort orders on one report

[CaroKannDefence via AccessMonster.com]

Hello.

I am building a report that shows stocks we are tracking. We are looking to
take either a Long or a Short position in each stock and have established a
target price for each.

The query underlying the report calculates the percentage variation between
the current and target price.

The report is grouped by long and short potential positions. What I'd like
(need) to have is for the group Short, a list by descending percentages
between the current and target prices. For the group Long, a list by
ascending percentages between the current and target prices.

Is it possible to have multiple sort orders in one report? I know I can
probably do this through VBA using a ranking system but I hope there might be
a simpler solution.

Thanks,
CKD

 

[Van T. Dinh]

I am not sure I understood your description but it sound like you can use a
Report with 2 SubReports, 1 for Long position and 1 for Short position. In
each SubReport, you can specify a different sort order.

 

[Guest]

I didn't realize AccessMonster and this newsgroup were connected.

I am not sure I understood your description but it sound like you can use a
Report with 2 SubReports, 1 for Long position and 1 for Short position. In
each SubReport, you can specify a different sort order.