Sorting different columns in report

[rhernand]

I have a report based on a query with eight different data columns. How can I sort any column that I want dynamically? In the form, where I choose the report; in the query, where the data comes from; or in the report, which prints the data columns?

 

[RichO]

I am not exactly sure what you mean by "dynamically", but if I understand your question correctly...

In report design view, select the Sorting and Grouping dialogue box and in there you can select which fields you want to sort by.

 

[Graham T]

rhernand

This might be what you are after -

Sorting Report Fields on the Fly

HTH

Graham

 

[rhernand]

Thanks, this is precisely what I needed

 

[rhernand]

Question

Graham T,

Is this example allowing for multiple row sorting? If I only want to choose one row to sort on, do I only have one combo list? The example has several.

Thanks, this is precisely what I needed

 

[Graham T]

Graham T,

Is this example allowing for multiple row sorting? If I only want to choose one row to sort on, do I only have one combo list? The example has several.

Yes. You can amend the amount of combo boxes to suit, also amending the code where required.

Graham