FMS developer Molly Pell is featured as a guest blogger on the Microsoft Access developer blog.

This post demonstrates how to use the Pivot statement to control column names returned by crosstab queries, allowing crosstabs to be used on reports.

Check out the full post, Using crosstab queries in reports.

For another paper with an example of Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query