Ask a process amounts

[azhar2006]

Hello all
I have a question about how to present material from the store POCKET

SELECT Sum(tblGroups.Mykmea) AS SumOfMykmea, NamSelvir.NamSelver, NamSelvir.totalAmount, NamSelvir.datepurchase, Sum([totalAmount]-[Mykmea]) AS Expr1
FROM NamSelvir RIGHT JOIN tblGroups ON NamSelvir.ID = tblGroups.TypeofSilverID
GROUP BY NamSelvir.NamSelver, NamSelvir.totalAmount, NamSelvir.datepurchase;

Why this error

[June7]

What error?

[rpeare]

What's the relationship between the tables TBLGROUPS, NAMSELVIR?

Is totalamount a calculated field?
If NAMSELVIR is a query what's the SQL driving that query

if this is something like a purchase order database it would seem that your query or table NAMSELVIR is the actual items the person or business purchased, but the 'totalamount' field is throwing me.

You might try Sum([TotalAmount]) - Max([mykmea]) but without knowing the relationship of the two objects it's hard to tell

[azhar2006]

[azhar2006]

Thank you all
I've brought me the solution rpeare
I have found the solution
It is
SELECT Sum(tblGroups.Mykmea) AS SumOfMykmea, NamSelvir.NamSelver, NamSelvir.totalAmount, NamSelvir.datepurchase, ([TotalAmount])-Sum([mykmea]) AS Expr2
FROM NamSelvir RIGHT JOIN tblGroups ON NamSelvir.ID = tblGroups.TypeofSilverID
GROUP BY NamSelvir.NamSelver, NamSelvir.totalAmount, NamSelvir.datepurchase;