sum of columns

[gdanalakshmi]

I have a crosstab query that produces varying number of columns. I feed the output of the query to the listbox.

I need a total of each column. Do I have to do a lot of programming of looping through and finding the sum? Or is there anythere way to do tha?

 

[gblack]

I might make a new table using the make table query (based on your crosstab query), it makes it easier to work with the data, even if it is a bit more clunky.

Once you have made the new table, you can make a query based on that, which uses the sum/grouping function in the query section.

Then base your list box on that.

later,
Gary

PS. Be careful, because the make table query is and action query, so if your data is being updated on a constant basis, you may need to wirte code in the form to rerun the make table query....