Search results

I am trying to group data from Table1 so that when the the first 5 columns are the same the values in the 6th column is multiplied together. (See Example Below). Table1: PPA IL CO ST 2000 1.10 PPA IL CO ST 2000 1.05 PPA IL EX PR 2001 0.95 PPA PA CO ST 2000 1.08 PPA PA EX...

I would like to do a select query that uses the totals to group records together. When you turn the totals on the choices you have for the value are things like sum, first, last, var, stdev, etc. I am interested in getting the multiplicative product. Is this possible? Any help will be...