MSHFlexGrid: Get Total for Rows and Columns
Dear VB Pros and Friends:
Questions about MSHFlexGrid:
adoRSAnalysis as ADODB.Recordset and it has 5 fields, each is assigned to
mshflexgrid from column 1 to 5.
Column 1 is the ItemName, Columns 2 to 5 are the numbers (US $ currency),
and Column 6 is the total for columns 2 to 5.
Question 1: how to polulate the adoRSAnalysis¡¯s result into the mshflexgrid?
Question 2: How to get the row total and show it on column 6?
Question 3: how to get the total for columns 2 to 5 on the last row (let¡¯s
say, there are 20 records).
Question 4: how to format ALL numbers in US currency like Format(.Text, ¡°$#,###,###.00¡±)
They results should look like this:
ItemName Column1 ... Column5 Total
ItemName1 $56.50 $220.52
Total $678.90 $2,555.83
Column 6 and the last row with ¡°Total¡± are the run-time results.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center