i am having tremendous trouble formating a pivot table form in access. i have to do my reports this way for my boss. its easier to control the amount of data in access. when i load a pivot table in access 2000 once it gets to the excel wizard it only loads 16 million or so records before it tells me it doesn't have enough memory. i have tried running the pivot table in access 2002, but i run into a problem with formatting it to have percents and so the row headings are seen parralell on the table. if anyone has any thoughts it would be very helpful.