Hey folks,
Anyone can help please... I am currently making an inventory of our office supplies. And honestly i a new with access. I knew only a few basic creation of this access.
I have created 3 tables; product list, purchases and issuances. 3 Tables are have relationship using product id field. 3 Tables works fine but my problem is making an inventory query/reports.
The query shows multiple the same products, what i wanted is to group same product and sum-up how many issuance or purchases have gone so far. I am not good in explaining so please refer on pics attached
Thank you very much