Answer the question
In order to leave comments, you need to log in
MS Access SQL how to get sum?
Such a query in MS Access displays a table of the contents of orders
SELECT OrderItem.ID, ProductID, OrderID, Quantity,
P.Title,P.CurrentPrice, P.ID, (P.CurrentPrice* OrderItem.Quantity) AS Total
FROM OrderItem
INNER JOIN Product AS P ON OrderItem.ProductID = P.ID
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question