I saw there is pivot table function (or something similar) in Access. I have over a million lines of data which I imported from Excel into access in a poor attempt to analyse it with Pivot function like I do in Excel. But I am too dumb to know to how to do it in Access. Can anyone give me some tip on this please? Or maybe I can still analyze the data in Excel with Pivot function, but how, with a million lines of data?
Thank you!
lili G.
Thank you!
lili G.