christheprogrammer
Programmer
Ok I feel like an idiot. How do you do this simple thing -
Here is an example of the fields:
Field1 Field2 Field3 Weight
apple sweet red 2
apple sweet red 3
orange sour orange 1
orange sour orange 3
orange sweet orange 6
And I want this:
apple sweet red 5
orange sour orange 4
orange sweet orange 6
The last field is just a sum of the others with the same field values...
I used to write complex SQL statements but I can't even do this now - definately not like riding a bike.. frustrating as hell
Cheers
Later
Here is an example of the fields:
Field1 Field2 Field3 Weight
apple sweet red 2
apple sweet red 3
orange sour orange 1
orange sour orange 3
orange sweet orange 6
And I want this:
apple sweet red 5
orange sour orange 4
orange sweet orange 6
The last field is just a sum of the others with the same field values...
I used to write complex SQL statements but I can't even do this now - definately not like riding a bike.. frustrating as hell
Cheers
Later