Subquery for total

[Fabdav]

I have query1 which shows a list of clients with their product and the price for each product
I need to add a column showing the sum value of the product
This is what i should obtain

Cust product value tot
Fab prod1. 100. 250
Fab prod2. 120. 250
Fab prod3. 30 250

[orange]

see http://allenbrowne.com/subquery-01.html
http://allenbrowne.com/subquery-02.html

[Fabdav]

I have tried but I can not sort out

[Fabdav]

Tried but with no succes

[orange]

Can you post a copy of your mdb? Or, failing that, can you post a copy of your
a)tables and relationships
b)your query sql
c) some sample data, and
d) a description of exactly what you want/need for output ( a sample output based on your sample data)

[Fabdav]

Ingnore this attached file

[Fabdav]

Wrong file

[Fabdav]

This is the right file
I need the result of query 3 in a single query

[orange]

What exactly do the fields represent?
It is not prudent to store calculated fields.
1 char field names are just about meaningless.

I'm trying to help and trying to understand what this data represents.