grouping on form

[ice051505]

Hi all, I have a form and report, my report is grouping by using the access group and sort button, but I also want the information grouped on my form. It's any button on the design field that can help me to do this? Or any code I should use here? Please give me some help here, Thanks a lot!!!

[June7]

Grouping is a report feature. On forms you can only sort. Sort with several fields can be defined in the form RecordSource or the SortBy property.

[ice051505]

Thanks June7,

Do you know how can I transfer the grouping feature to excel from a report that each worksheet only contain one group, which means multiple worksheet in one excel based on the different group?

Grouping is a report feature. On forms you can only sort. Sort with several fields can be defined in the form RecordSource or the SortBy property.

[June7]

Reports don't always export nicely, especially if there is grouping and/or subreports involved.

What you want will require looping VBA code to open filtered query and export to worksheet. Exporting to new pages of existing or newly created workbook gets rather complicated.

Exporting to Excel with VBA is a common topic. Search forum or Google. Here is a start: http://forums.aspfree.com/microsoft-...el-414974.html