access to pivot table

[yogi]

I know how to create a pivot table in xls from access

I need to know how to use VBA code to populate a format table in xls

any book that you recommned or website that could help me program what i need

thanks