I am running two separate queries and obtain 2 recordsets. One of the queries ia an standard query and the other is an aggregate query. One will return a measurement for a person while the other will return average, min, max measurements for a collection of people.
I want to display the result in a single listbox. So I will have columns in the listbox such as personID,personValue,GroupAvg,GroupMin,GroupMax
So first, how can I combine the recordsets? If this is not possible, then how can I populate a multicolumn listbox with those columns when getting the results from 2 recordsets? If necessary, the recordsets can be combined in a multidim array and then use that to populate the multicol listbox.