Query shows duplicate

[John thomas]

Help please
I hve a query that I want to total soldAtPrice *quantity This information is stored in my order details table and mus not change .I can do a calculated field to get the answer but the Problem is if there are 2 recodrs to be totaled the query displays 2 records if there are 3 records the query dislplays 3 records and so on .I need one record to be displayed with the total of all the recodrs

 

[CJ_London]

try using a group by query and sum the values you want

 

[John thomas]

Hi thaidear whonks for your time
Never used a group by query could you give a brief idear of how to do this
Many thanks

 

[John thomas]

Re:SOLVED Query shows duplicate

Yes you were correct I sum the total and all works well
Thanks for your help