Summary Report

[Guest]

I need to create a summary report for my customer db. The first thing I need
to do is create a summary query and then create the report. Here's what I
want to do:

I need the report to list the customers on the left side vertically and then
across the top horizontally I need to have it list the "Product Type". These
will be the report titles. And then I need it to list the dollar amounts for
each "Product Type" for each customer. I want to be able to run this by
selecting a month/year as the criteria. Can anyone help walk me through this?

 

[Steve Schapel]

Squirrel,

This sounds like a job for a Crosstab Query, and then your report based
on this query.

See if you can read up on Crosstabs in your Access book, or in Help.
After that, if you still want "walk through", you will need to provide
more details and examples, with the data you are working with.