Hi guys, can someone help me with this simple calculation in access? For our task at uni we need to make a query, however we didn't get much info about it, it's almost self-studing
I just need to make a simple calculation where I can see how much stock there is.
As a company I sell 10 different items. I have a table with all the sales on different dates.
Here is the problem I have:
I bought 100 pieces of Item1 and only sold 20pieces. So I have 80 pieces left.
Later I sold 40 pieces of Item1, so there is only 40 left.
When I put this into a query, I take the amount of goods I purchased + the amount of good I sold (from the tabel of al the sales). When I run the query, I do not see 40 as a result. I see two lines:
Item 1 purchased 100 sold 20 stock 80
Item 1 purchased 100 sold 40 stock 60
How can I put this into one line so I can see 40 as a result?
I just need to make a simple calculation where I can see how much stock there is.
As a company I sell 10 different items. I have a table with all the sales on different dates.
Here is the problem I have:
I bought 100 pieces of Item1 and only sold 20pieces. So I have 80 pieces left.
Later I sold 40 pieces of Item1, so there is only 40 left.
When I put this into a query, I take the amount of goods I purchased + the amount of good I sold (from the tabel of al the sales). When I run the query, I do not see 40 as a result. I see two lines:
Item 1 purchased 100 sold 20 stock 80
Item 1 purchased 100 sold 40 stock 60
How can I put this into one line so I can see 40 as a result?