Place two different records in one report

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I am using Access 2002 and I would like to have a report that will show two
different records in one 8x11 sheet. The sheet actually tears apart in
half. For example:


Reliance Insurance
10322 Farmington Grove $500,000






ReAliance Insurance
7800 Day Ave $400,000




Every sheet will have two different records and there are about 100 records.
How do I do this. If I go into the detail band I only will get one record
at a time. Can anyone help me. Thank you in advance.

Cheers
 
Cam,

Hope this suggestion helps you. I had two different bank statements that I
wanted to view on the same financial statement.

I created subreports for each portion ie, income section, expense section On
the main report, I opened it with a banking header within which I put the
beginning balance. I then, in the detail section, put the income section and
expense section. This all went on the left side of the report. on the right
side of the page, I created a separate report in which I put the same
information as in the first report only called the report for the left side,
LCBPortion.

within that LCBPortion, I had the beginning balance, the income section, the
expense section, and in the banking footer, I added the
=[begbal]+[txtincrun]-[txtexprun].

Also, within the detail section of each report, I added
=IIF(SubRpt.LCBincome].[report].[has
data].[SubRpt.LCBIncome].[Report].[TxtIncomeSum],0]

In addition, you must make that same statement for each sub-report you have
within the main report. Of course, you will substitute the actual name of the
sub-report rather than SubRpt.LCBincome. ie you would put [SubRpt_LCBExpense]
An important thing is to make sure all your names are exactly as they appear
with the sub-report or text boxes. If not, you will have to go back and
change things. It is not fun to have to do that and it is very time consuming.

Best of Luck,
Karen
 
Thanks I will give it a try.

Cheers

znibk said:
Cam,

Hope this suggestion helps you. I had two different bank statements that I
wanted to view on the same financial statement.

I created subreports for each portion ie, income section, expense section
On
the main report, I opened it with a banking header within which I put the
beginning balance. I then, in the detail section, put the income section
and
expense section. This all went on the left side of the report. on the
right
side of the page, I created a separate report in which I put the same
information as in the first report only called the report for the left
side,
LCBPortion.

within that LCBPortion, I had the beginning balance, the income section,
the
expense section, and in the banking footer, I added the
=[begbal]+[txtincrun]-[txtexprun].

Also, within the detail section of each report, I added
=IIF(SubRpt.LCBincome].[report].[has
data].[SubRpt.LCBIncome].[Report].[TxtIncomeSum],0]

In addition, you must make that same statement for each sub-report you
have
within the main report. Of course, you will substitute the actual name of
the
sub-report rather than SubRpt.LCBincome. ie you would put
[SubRpt_LCBExpense]
An important thing is to make sure all your names are exactly as they
appear
with the sub-report or text boxes. If not, you will have to go back and
change things. It is not fun to have to do that and it is very time
consuming.

Best of Luck,
Karen


CAM said:
Hello,

I am using Access 2002 and I would like to have a report that will show
two
different records in one 8x11 sheet. The sheet actually tears apart in
half. For example:


Reliance Insurance
10322 Farmington Grove $500,000






ReAliance Insurance
7800 Day Ave $400,000




Every sheet will have two different records and there are about 100
records.
How do I do this. If I go into the detail band I only will get one
record
at a time. Can anyone help me. Thank you in advance.

Cheers
Click to expand...
Click to expand...
 
Back
Top