Copy SubTotal of Order Detail

[francogaspari]

hi
how can i get the total amount that i get its Sum in a form to appear in the table or query?

[ItsMe]

Calculations are not usually stored in tables. Have you tried building a query object using the Query Builder? There is a "Totals" option in the Ribbon.

[francogaspari]

Thank you "ItsMe"
i made a query of Total orders and i made a SUM of unit prices in OrderDetails, so it work well, but i still have to display all these products made by OrderID and Client in one phrase. can that be done?

[June7]

What means 'in one phrase'?

Perhaps you need to build a report and use its Sorting & Grouping features with aggregate calcs in footers.

[francogaspari]

i mean :
in Order "1" the client purchase "milk - 2$" + "cake - 1$" , so in a a query i made the SUM of Order 1 what is 3$ , So what i need is to display these products in one ROW like "Milk+Cake" . Cause when i display the Products in the query the Total SUM disappeared

[June7]

What do you think about the report suggestion? It will allow display of detail records as well as summary calcs. Don't do summary calc in query. Do it on the report.

[francogaspari]

ok . i will do it . thank you anyway