>>>Hi all,
>>>
>>>I have a genxTab query here which I want to display in the grid. My query results have customer name in rows and days of months in columns. I require row as well as column TOTALS. The genXTab does the row totals for me.
>>>
>>>I would like to know if there is a way for getting the column totals.
>>>
>>>Thanks
>>
>>You can easily total columns in grid, adding one more column with expression (sum of other fields) as controlsource.
>
>Sorry to intrude. I don't have a problem with the totals but I am not sure about saving the result.
>
>I am also trying to use GenxTab but I need to save the information back to the original table. Do I have to scan each cell and update or I can use an updatable view to save?
>
>Any opinion? Which is the best way?
I didn't here about cross-tab updatable views. You can do something with scanning, though croos-tabulation usually involves some summarizations and usually it will be difficult to retrieve changes back to original tables. Basically, cross-tabulations is for viewing data in user-friendly form.
Edward Pikman
Independent Consultant