I have been doing some research lately on how to make a dynamic crosstab report. I have the solutions database from the access 97 cd and have seen thier example. I just can't figure out how to make that apply to my database. I am struggling with it.

I am going to attach my database in the post.

Can some please look at the database and let me know what I need to do to get the dynamic report going.

The crosstab query in the database is called PROJECTS_OPEN_LAST12WKS03_Crosstab.

Any help will be greatly appreciated.

Thanks,
Brian Weber