Summing Columns in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table that look like this:

Rank 1 NAVY BLACK TAN CHRCL SPRUC
LONG 1.3
LONG 10.4 0 0.965
LONG 6.5 1.855 1.53
LONG 0 0.28
LONG 4.725 2.365 1.02 2.6


I am looking for a way to sum the columns for the Colors; however, the
number of columns may and can change. I.E, there may be more colors to sum
or less colors to sum. There also may be different colors that are not
listed.

After this function, I will want to do a Standard Deviation on the columns
in the same method.

Let me know if you have any ideas.

Thanks.
 
Danny,

Thanks for the response. I have watched a few of the tutorials, however, in
my example, the column headings will be dynamic meaning each time I create
the table I listed, the # of column headings will change.

The tutorial on their site uses the Union Query to show totals and detail on
the same Table which I will do once I am able to build a query that will work
with cynamic columns.

Chris
 
If your tables were properly normalized, you wouldn't require dynamic
columns. Is there a reason why you are using colors as field names?
 
Will a crosstab query work for you?

Chris said:
Danny,

Thanks for the response. I have watched a few of the tutorials, however, in
my example, the column headings will be dynamic meaning each time I create
the table I listed, the # of column headings will change.

The tutorial on their site uses the Union Query to show totals and detail on
the same Table which I will do once I am able to build a query that will work
with cynamic columns.

Chris
Click to expand...
 
Back
Top