add values for different products and get their total amount

[gerryis2000]

I would like to add values for different products and get the total value in Ma access.
e.g

PRODUCT_NAME UNIT_PRICE QUONTITY
Fanta 100 10
Cock 80 5
Pepsi 70 15

Now How do i get total for the three comodities and represent the expression in a field in ms access querry or form?

Thanks,

Regards,
Gerald.

[mcupito]

If you're trying to get a sum of a specific field, it would be something like this (for "Quontity") but are just trying to Sum each row?

SELECT e.ProductName, e.UnitPrice,e.UnitQuontity,
(SELECT 
 SUM(y.Quontity)
                From YourTable AS y)  AS SumAmt
FROM YourTable AS e

[NeoPa]

The SQL subquery approach illustrated by Mark is an answer for getting the value into a query when you also want to see all the determining records. If only the total is required then a simpler aggregate query is all that's required (No subquery).

In a form or report though, you can total using the Sum() function. This is possible anywhere, but is usually handled in the Form or Report footer sections.

[mcupito]

Thanks for clearing that up for me, NeoPa. I wish the OPs would return often enough and provide more clarity or let us know if our solution worked xP.