nickg96

Hello....

this question is rather long, so please bear with me....

i'm working on a database application for a client. The system creates pre-formated reports in ms access. The users have no prior experience with report or query design, so everything must be pre-formatted.

the user wants to be able to query the database, create reports, and save those reports. In order to fullfill thier needs, i created an entire front-end comprised of forms. These forms include sub-forms, these sub-forms include pre-created queries. Within these queries are fields formated as check-boxes. The user checks off the boxes adjacent to the row of records that he wants to include in the report. Once all the records are selected, the user presses a control button and the approprite report is opened. The report now includes all the records the user selected form the previous form (actually, the query located in the form).

I was also able to save the queries (the ones located in the form) as a table. This enables the check-boxes they selected to now remain static. Thus, this enables the user to save a report. They don't actually save the report, they save the underlying query. I created another form that has a combo-box that stores the names of all the queries. The user can then select the name of the saved table, and press another control button. After pressing the button, a report opens up that uses the selected saved table as the record-set.

ok, now here is the problem:
there are 5 seperate reports that exist in the database application. These 5 reports are put together (manually, by hand) by the user to create a marketing package for clients. My client now wants all of these five reports to print out as one single large report. He wants the page numbers at the bottom of the report to reflect that it is a single report (thus instead of 5 reports, each with numbered pages 1-3...he wants one report with page numbers 1-25).

He also wants this new single report to be saved as a single name.

the problem is I use 5 seperate queries for each of the 5 reports. Each of these 5 queries are saved as five seperate tables. As i mentioned before, these 5 seperate tables are used as the record-source for the "saved" reports. Thus these 5 seperate tables have 5 disticnt names. Thus, for each "Marketing Package" (which consists of all five reports) there are 5 different names which describes it...such as:

Client 1- Profile Report
Client 1- Customer Referecnes Report
Client 1- Trade References Report
Client 1- Completed Projects Report
Client 1- Current Projects Report

To try and solve this problem, I took all five of the queries and put them into a single report. But the design area of the report is not large enough to house all of the sub-queries. I know if i could get all the sub-queries to fit into a single report....i could save the report as a single name......and use the single name as a "base name" for the reports recordsource tables.......i would take the report name and add static extentions to them. But I can't figure out how to put all the report sub-queries and text boxes into a single report

Sorry for how long this question is, but it was the only way I could think of to explain my situation.

If anyone could help me out, i would really appreciated it

thanks

Robby

You can make a new report and take each of the five and place them as a sub-report.(of the new report).

I really don't like the way you are saving the querries as tables, you can simply place an SQL statement as the record-source of each report. (or even a query that you filter via VB code)

nickg96

yeah...i tried that....i placed each of them into the new single report...but the design size of the report is too small...i can't fit all of them....

also, how would i be albe to use a sql statement as the record source? The record-source of the report needs to remain static. The record-source will change once the user changes which check-boxes are checked (or not checked) in the query. See, when i save the query as a table, the check boxes become static because the user can't change them

I know this isn't the most effective way of handling things, but i'm new and thats the best i could come up with

If you have anymore suggestions, please share them with me....thanks for your help

Robby

When you place a sub-report on a main report you don't need to make it full size (let's say 11 inches / 28 cm) You can make them 1 inch and set the CanGrow property to True.

nickg96

This issue has been resolved...thanks to all that helped!