Search results

So... I have made a query where I can see the amount of sales per item its this: Items---------------Sales Item 1----------------2 Item 2----------------5 Item 3----------------2 Total sold-------------9 So now I have to make another query? Can I not just make a table with the...

Hii Guys As for school I need to work with Access and set up some queries. I'm almost there but still miss just one little thing in my work, and I don't have that much experience with Access. Here is my problem: I have a table were I sell items Items---------------Sales--------------% (I...

Thank you isladogs! I have a feeling I'm almost there!! Here is another problem I get when I do what you told me - So I have a list of the purchases I made (I purchased for the ten items I sell 100 pieces) - I also have a list of the sales --> I sold Item1 two times (first time I sold 20...

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...