Sorting according to field chosen after report previewed

[Guest]

I have a report based on a parameter query. In the detail section, there are
several fields such as Field1, Field2, Field3 etc. The report is already
sorted according to one field, say Field1. How can I introduce a feature into
my report by which it can be sorted by another field chosen by the user of
the report, say Field2. Something like having clickable field headings and
the sort order changes according to the field heading clicked upon the
user...

 

[Guest]

Can someone advise please, if this can be done in Access

 

[Duane Hookom]

See if this solution meets your needs http://allenbrowne.com/ser-33.html.