Stock DB

[315hughes]

Hi am attempting to create a stock database for work. i have created a query called TotalStaffOrders and a query called TotalStockOrders this gives me the total of each item that has been ordered either for stock or staff. It displays total, StockDesc and Size. What i am attempting to do is subtract the totals from the staff table from the stock table where the descriptions are the same. Below is my attempt it does subtract but it subtracts from each value of the stock table.
Thanks for your help

SELECT [SumOfSSQuantity]-[SumOfQuantity] AS [Total Left], TotalStockOrders.StockDesc, TotalStockOrders.Size
FROM TotalStaffOrders, TotalStockOrders
GROUP BY [SumOfSSQuantity]-[SumOfQuantity], TotalStockOrders.StockDesc, TotalStockOrders.Size;

[sierra7]

Hi
There is no join statement in you query so it is impossible for Access to know how to relate TotalStaffOrders with TotalStockOrders.

Furthermore, if these two queries are already summing the items, I can't see why you want a Group By clause.

Perhaps, if you write out the details of these two queries, someone can help.

S7