I Need Report Help

[confused2004]

I am currently using Access 97. I have a 50 page report that I would like to save as separate reports for each one page record on the report. I would like to key off the project desc field. Can anyone help me with the coding of this in a macro or module? Thanks in advance

 

[straybullet]

If each Proj desc goes on a separate page, if you set up the query the report is based on to prompt for the specific proj desc, you will only get that page in your report. 50 separate reports seems a bit cumbersome to scroll through to find the desired one.

 

[Steve101]

In your report Design, set up a 'Sorting and Grouping' field (use View, Sorting And Grouping menu options) based on the Project Description field; ie. add this field to the first row of the Sorting and Grouping dialogue box.

In the Group properties at the bottom of this dialog box, set the Group Header property to Yes. This will make visible a Group Header section in the report for the Project Description. If you click on the grey bar associated with this group header and display the section properties at the same time, you'll see that one of the properies of this header is 'Force New Page'. Set this property value to 'Before Section'. This will force a new page before each section (in your case, before each property).

By careful placement of your Project description field in either the page header of the new section header, you'll find that you can produce each Project on separate pages.

Have a play with this, and see how you go.

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[confused2004]

Thanks alot. Everything is working well now. I'm still having trouble with the saving all of this to .pdf. I would like to create a separate file for each project desc. Can this be done?

 

[MAM8512]

I am using MS Access 2000 and I am trying to create a query that that would gather info from table 1 (income) and table (expenses) for a report. I need for each entry to follow date sequence (income, expense) in the report. Both income & expense tables will have combo boxes that list 5 different Accounts in which the money comes in or goes out. The reason why I am using two seperate tables (income, expense) for this info is because of the different fields in each table. What I want the report to do is give me a running balance of a certain account, so that I can make sure that the account never goes into negative. PLEASE HELP.

 

[tracy1234]

MAM8512 - the short answer is to create a query to join the two tables and select the fields you need for the report. Then base your report on the query. Look into the running sum property for your report.

As your question differs from the one posted on this thread and the original poster still is asking for help, you should start a thread of your own with additional questions.

-Tracy

 

[confused2004]

Thanks for your question MAM8512. I think you should have started your own thread for it, instead of posting on mine.