Hi,
I have a query with two columns: one is used as a grouping column and in second one i'd like to get the product of grouped data(numbers) within that column. Is there a possibility of multiplying
grouped data? (this is not an option among Sum, Avg, Min, Max and others offered). If not, is there some other way to do it?
Thanks

Hi,
I have a query with two columns: one is used as a grouping column and in second one i'd like to get the product of grouped data(numbers) within that column. Is there a possibility of multiplying
grouped data? (this is not an option among Sum, Avg, Min, Max and others offered). If not, is there some other way to do it?
Thanks

Please provide more info.
Query sql, table

sql is: SELECT Sheet1.[Vrsta VP], Sum(Sheet1.Kolicina) AS SumOfKolicina
FROM Sheet1
GROUP BY Sheet1.[Vrsta VP];

What I'd need is to get the Product of 'Kolicina' instead of Sum. So that for each of 'Vrsta VP' values it would return group product of 'Kolicina'

The product of all the values for that field in every record?
Perhaps the data could be structured differently to make this calculation more readily achievable.

First column is Text type, and second is Number. So if in text column I have let say Blue, Red and Violet and in Number column 10,4,15,5,20 and 10 and 4 are under Blue, I'd like to get product(40) - basicaly grouping by text and product within each group by number.

What is the maximum number of possible numerical values in a group?

hm, i guess maximum would be around 100 values

I think that you would have to use code, reading a recordset sorted on the TEXT field and with the crudely expressed logic below, which is not pseudo programming.

Get 1st record
Loop1: Move record field to productfield
Loop2: Get next record
If new group or eof
Output record
If eof exit
Else goto loop1
Endif
Else productfield =record field*productfield
Endif
Goto loop2

Brian