Change GROUPING programmatically in reports

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Here's the deal: In Access 2003, I have a report. I need to be able to change
the "minor sort" programmatically via VBA (if I have to do that before I open
the report, that's okay.) This would involve making changes to the SORTING
AND GROUPING portion of the report. I would not need to SAVE those changes.
the minor sort needs to change based on a set of radio buttons. The
associated subtotals would need to be made visible/invisible based on that
grouping.

And assistance that someone could offer would sure be appreciated.

TIA!
 
One way is to add a calculated field in your query feeding the report.
Have an IIF statement testing your radio buttons like this --
My_Sort: IIF([Forms]![YourForm]![Button1] = -1,
[YourDataTable].[FieldToSort], "0")

Leave off the quotes if it is a numerical field.
 
WOOHOOO!!!

Thanks Marshall! You did it again. that was exactly what I was looking for!!!
 
Back
Top