MshFlexGrid ....Display Totals at the change of a

I Am using MshFlexGrid to display various summary details

I want solution for following

1. I can merger a particular Column but I want to merge 2 columns and display the data accordingly.

2. Dispay totals
Say I am displaying Customerwise Account receivable. I want to display TOTALS at the change of Customer.

I FOUND THIS FORUM AS BEST FORUM FOR THE ACCURATE INFORMATION AND PROMPT RESPONSE.

Not Sure If I Understand the Problem but here goes anyway,

By iterating through the msFlexGrid.Textmatrix() Property it is possible to read, and or change the values displyed,

i.e.

Dim tot as long
' imagine col to add up= 3rd col ( 0,1,2) 
' leave out row 0 as it usually has headings 
for x = 1 to me.msflexgrid1.Rows
    tot = tot + me.msflexgrid1.textmatrix(2,x)
next
msgbox "Total of Col 3 = " & tot

Hope this helps

Please help me...

Send me code so as insert summary totals as the customerchanges in flexigrip

Thanking u in advance...

Vikas Athavale

hi there,
I kinda have the same project as yours. I'm doing an accounting system using VB + Ms Access. I'm having trouble with the ledger posting and also the journal. Could you pls advice with samples ?

Have a nice day

How are you loading the data into your grid? If you use a SQL query in your code (as opposed to selecting tables from the Properties window), you can add a calculated TOTAL field to the table that is returned to the grid.