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
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