By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Generating large volume reports in Access

P: n/a
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,
Dec 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 20 Dec 2007 00:45:55 -0800 (PST), si********@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,
Dec 20 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.