Grouping by more than one field

Henley12

Troy University Fan
Local time
Yesterday, 20:22
Joined
Oct 10, 2007
Messages
222
I have a form that has a combo box of fields to choose for grouping a report. The users want to be able to group by more than one field at a time. Is this possible? Here is my grouping logic attached to the run button:

If lstGroupBy.ItemsSelected.Count > 0 Then
strIDs = ";"
For lngLoop = 0 To lstGroupBy.ItemsSelected.Count - 1
strIDs = strIDs & lstGroupBy.ItemData(lstGroupBy.ItemsSelected(lngLoop)) & ";"
Next lngLoop
txtString = strIDs
Else
txtString = ""
End If
 

Users who are viewing this thread

Back
Top Bottom