What is "detail in columns"? Calc's pivot tables can be linked to registered databases.Tools>Options>Base>Databases, add your database under some name.Calc menu:Data>PivotTable>Create...[X]Create from registered database ...

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x

Please do not move away from MS Access. Once you used Access only for some time, you will not be able to use anything else. I don't know why. If you want to use your Access data in the context of this office suite, you can connect a Base document to your .mdb and add some queries to the Base document (including pass-through queries which are interpreted by the JET driver so you may even use the datedif function)

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x