Hi,

I 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,

Go back to your report in design view.

All of your vendor information should be in the DETAILS section.
If they're not, expland the Details section and move them into it.
Right click on the grey bar on the details section and select Properties.
Check the Page Break selection. It should be on none.

Hi,

Thanks, that has created the reports in a manageable fashion. Leading on from this, on the final report for each page, how would I go about adding a total for all of the spending under each catagory?