REPORT COMBINATION

[iniohosdelphi]

I Have two reports generated from different data tables
I would like to combine then and produce a new report
from them in this way
The pages from the first report will
be the odd pages of the new report
The pages from the second report will be
the even pages of the new report
If two reports have different total page number
I would like to add blank pages
when the pages of the smallest report finish

Best regards
Iniohosdelphi

 

[Gina Whipp]

iniohosdelphi,

I am not even sure this is possible BUT throwing some thoughts around in my
head and I feel like trying the impossible...

I would....
1. Create a Query for each table that counts the records and also adds a "1"
in a seperate field for one table and a 2 for the same field in another
table. Not sure how I would keep the queries with the same count of records
but these are just ideas.
2. Create a Union query with the two above queries... Depending on the
record count this could take a bit to run.
3. Order the Union query and Order By the row counting field first and the
field that has the number you assigned in Step 1.
4. Base you report off of that query.
5. Run report...

There might be a better way to do this but just thinking out loud here...
Of course, the better question would be, WHY are you doing this? Knowing
the reason might offer soe insight into a better way to do this!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm