Thanks for your response, but my problem is that my access version does not have the option to create either a pivot chart or a pivot view, I would like to know how can I install additional tool kit or add-ins.
I have seen some tutorial videos on youtube where you can create pivot tables in access (not crosstab) under forms, but in my access version(2007-2016) I don't see the icon or option, do I need to install any add-in?