Getting query results in a report

[MarcieFess]

I'm having trouble creating reports in Access.

I have a database of several linked tables. I'm getting the required fields from the various tables into my report just fine.

My issue is that I need to get the results of a query, titled QuantityOnHandQuery, into my report. I'm not having any luck, because when I try to do a Print Preview, it's asking me for a parameter for that field.

I want ALL of the records to print, not just one particular QOH. I need the report to print by Hazard Class (which is in my page header as well as the left-most column in the report); at the end of every Hazard Class, I need it to print a Total of that Hazard Class AND I need to figure out how to store that total, because it's needed in a second report.

I need each Hazard Class to begin on a new page.

I need each Hazard Class to have page numbers "X of XX" and to begin numbering at 1 for each new Hazard Class.

I have troubles with Access reporting. If I were doing this for something to use personally, I'd create a MS Word document and have no troubles. I cannot do that here, because it's for a client that wants it all self-contained in Access.

Please help! They want me to prove that these reports can be generated and I only have until noon tomorrow.

Marcie Fessler

 

[MarcieFess]

I realized I was unclear...I need the report to total all of the QOH for each Hazard Class, and print that total at the bottom of each section. I also need those totals saved somewhere, as they have to be used to generate another set of reports that compares that total to a set of parameters for each hazard class and indicates whether or not permits are required for that hazard class.