Ad hoc grouping

[nileshtx]

I need to create a form that shows data from a table in data sheettype of format. My problem is i need to find a way to let the user of the form pick which fields to group by, how many fields form the table to group with, and what order the fields should be grouped by.

 

[Pat Hartman]

There is no way to do this on the fly. You would need to create a form where the user would specify his requirements and you would need to create an SQL statement to satisfy them and use that SQL statement as the recordsource of the datasheet form.

Creating a Pivot table might work better for you.