Dynamic Report Sorting

[jamie13]

Is there any way to give the user different options of how they want to see a report being sorted, or do you need to have separate reports for every sort required?

Thanks
Jamie

 

[LarryDeLaruelle]

Jamie:

Reports have an Order By property that can be set dynamically with macros and visual basic.

If you use visual basic, you would need to give the user the option via form, set the user selected order in a text box and then in the report's On Open event reference the sort order:

Me.OrderBy = Forms!frmOptionForm.txtSortOrder

I've not used this before but this should work. You may need to tinker with it a bit. Check Access help for the the proper way to identify the sort order criteria.

I don't use macros so I can't offer any suggestions on those.

Hope that helps. Larry De Laruelle
ldelaruelle@familychildrenscenter.org