Hi
Working on an inventory database. I have Four different tables containing Opening, Receiving, Issuing and Returns of items with different dates. I wish to join them in a single query which contain only transaction type and transaction date (sort on date).
I am new to MS Access, was able to do this in MS Excel but database is getting bigger and slower. Would appreciate any help and thanks in advance.
Table1 Item.Items Opening.Quantity Opening.OpeningDate
Table2 Item.Items Receiving.Quantity Receiving.RecvdDate
Table3 Item.Items Issuing.Quantity Issuing.IssueDate
Table4 Item.Items Returns.Quantity Returns.RetDate
Required Query: Sort on Transaction.Date
Query1 Item.Items Transaction.Type (Open, Receiving, Issue, Returns) Transaction.Date(OpeningDate, RecvdDate, IssueDate, RetDate)
Kindly also guide if images of the required table and queries will be helpful in understanding and answering my question.