Generating large volume reports in Access

[simon.vito]

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,

[Tom van Stiphout]

On Thu, 20 Dec 2007 00:45:55 -0800 (PST), si********@goog lemail.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
classificati on 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,