I know this is a very very late answer to this question but this is more for anyone else to Google this question. I suggest looking up team-moeller better access charts and better access pivot table. You can look up AEK GUIwithHTML and Access in the Company. They all show great ways to do what your asking.