event though there are some thread which is talking about
combining a recordset i cound not find anything about a problem I have.
well i have one table from this table I would like to extract
some grouped by fields and a single field from the same table.
say
strSQL = "Select City , sum(q1) from table1 group by City"
Rs.Open, strSQL, myConnection, adOpenKeyset, adLockOptimistic
Now i also want a field called facilityName from the same table.
which i need to list and place it in the same recordset.
I was thingking of creating two recordsets and combine them
into a 3rd recordset that did not work out.
any Idea or suggestions is appreciated.
combining a recordset i cound not find anything about a problem I have.
well i have one table from this table I would like to extract
some grouped by fields and a single field from the same table.
say
strSQL = "Select City , sum(q1) from table1 group by City"
Rs.Open, strSQL, myConnection, adOpenKeyset, adLockOptimistic
Now i also want a field called facilityName from the same table.
which i need to list and place it in the same recordset.
I was thingking of creating two recordsets and combine them
into a 3rd recordset that did not work out.
any Idea or suggestions is appreciated.
