Forum Discussion
Transpose tables in access365
Yes you can do this in Access. If it was for me I would end the use of the Excelsheet because you are keeping track of data what is added all the time. Excel is then not the way to go and Access is.
It is not difficult to set this up but needs some basic skills to create the database.
First you can not delete the Excel sheets so you need to import the information to the Access database.
It would be nice if in the Excel sheet is a column where is registered a partnumber so you can identify every part as unique. If not then you have another challenge 🙂
Well I would suggest a imported table based on the sheet where are the parts. A connected table to the excelsheet I would use to query the new parts so you don't have to check it manualy.
Second I would use the same construction for the transactions. One table with the transactions imported from the excelsheet and second one connected to the excelsheet. Also here is the need to identify the part so the partnumber should be unique in the table.
A form with the parts and a subform with the transactions would give you then the result you want.
There are some skills required to achieve this but a 10-12 hour online course would do the trick I think.
Greetings,
Marcel