Problem in Consult

[gatarossi]

Dear all,

I have a table with this information:

code qtde vlrUnit
10 100 0,5
10 150 1,0
10 200 1,5

and I'm trying to do a consult to obtain this:

cde qtde vlrUnit
10 450 1,1111

but I don't known if I put total in my consult because access sum the
unit value...

Thanks a lot!!!

André.

 

[Wolfgang Kais]

Hello André.

Dear all.
I have a table with this information:

code qtde vlrUnit
10 100 0,5
10 150 1,0
10 200 1,5

and I'm trying to do a consult to obtain this:

cde qtde vlrUnit
10 450 1,1111

but I don't known if I put total in my consult because
access sum the unit value...

The code is used for grouping, qtde seems so be a simple sum:
qtde: sum(qtde)
and the vlrUnit seems to be a weighted average:
vlrUnit: sum(qtde*vlrUnit)/sum(qtde)

The sql will look like this:
SELECT code, Sum(qtde) AS s, Sum(qtde*vlrUnit)/Sum(qtde) AS v
FROM Table1 GROUP BY code;