Search results

The_Doc_Man: Pretty slick trick....I think this just might work for what I'm trying to do.

David R - You can just ignore Table2. I am asking the same question as I asked in the Queries forum.

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...

Thanks for the help David R. I was hoping that there was a way to do this without using recordsets. A more detailed example of what I'm trying to do is....starting with that data: IL 2002 1.05 IL 2002 1.10 IL 2002 0.95 PA 2001 1.08 TN 2001 1.02 TN 2002 0.95 TN 2002 0.85 I...

Sorry I wasn't very clear.... If I starting with the data: IL 2002 1.05 IL 2002 1.10 IL 2002 0.95 I would like to get the result: IL 2002 1.09725 Where 1.09725 = 1.05*1.10*0.95

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...