Generating large volume reports in Access

am currently working on a project which the main application we
intended to use has fell through, so we have falled back on Access to
work through this.

The information we have imported into a single table contains
information from the spreadsheet with the following details:

Vendor Number
Vendor Name
Amount spent
Number of Invoices Raised
Type of Spend (Simply Influenceable or Non)
Contracted Spend (Simply Yes or No)

And finally an industry classification with regards to what goods/
services a vendor supplies in the following fields:

Key Number
Code Number
Code Description
Level

The aim is to generate reports to group these vendors together by the
classification so that we can see how much in total was spent for one
classification, eg stationary, for both Contracted and Non Contracted
spend.

I attempted this briefly through the Reports Wizard and it didn't
output in a useful format, instead giving 200+ single pages, rather
than a list and total which I need.

What would be the best way of approaching this?

Any advice will be gratefully welcomed.

Thanks,

Re: Generating large volume reports in Access

On Thu, 20 Dec 2007 00:45:55 -0800 (PST), simon.vito@googlemail.com
wrote:

Sounds like you need a crosstab query. There is a query wizard for it.
-Tom.


> am currently working on a project which the main application we
>intended to use has fell through, so we have falled back on Access to
>work through this.
>
>The information we have imported into a single table contains
>information from the spreadsheet with the following details:
>
>Vendor Number
>Vendor Name
>Amount spent
>Number of Invoices Raised
>Type of Spend (Simply Influenceable or Non)
>Contracted Spend (Simply Yes or No)
>
>And finally an industry classification with regards to what goods/
>services a vendor supplies in the following fields:
>
>Key Number
>Code Number
>Code Description
>Level
>
>The aim is to generate reports to group these vendors together by the
>classification so that we can see how much in total was spent for one
>classification, eg stationary, for both Contracted and Non Contracted
>spend.
>
>I attempted this briefly through the Reports Wizard and it didn't
>output in a useful format, instead giving 200+ single pages, rather
>than a list and total which I need.
>
>What would be the best way of approaching this?
>
>Any advice will be gratefully welcomed.
>
>Thanks,