Update query and also a sum.

[Marco]

Hi.

I have a problem here that I can't figured out a solution.

I have a query this this fields and values:

ProdctionNo Production Value1 Value2
Value3 Value4
12008 ABC 10 20
0 25
12008 ABC 15 10
0 5
12008 XRT 20 30
0 45

and I need that one query or more queries Sum the value by Product and put
it on the first producto line in order to have this. But I don't won't to
delete the second line.

ProdctionNo Production Value1 Value2
Value3 Value4
12008 ABC 25 30
30 25
12008 XRT 20 30
0 45

Is it possible?

Regards.
Marco

 

[Dennis]

Put your six fields in the order you have in your query and then click on the
Sigma (Totals) button on your toolbar. This will put a totals row in you
query grid with a default of group by against each column. Leave group by for
your first 2 columns but change your 4 value columns to Sum

 

[Marco]

I'm sorry. I dind't understand.


Cheers,
Marco

 

[Dennis]

Is it my English ? my whole answer ? or part of my answer ?

 

[Marco]

I create soma make tables queries and I think is ok now.

if it works I'll tell you.