Sub Report

[Duane]

I have a report where there are two sub reports in the detail section. One
is called 8hourdays and the other is called 10hourdays.

Each sub report uses a parameter query, using the txtjob control on the
billing form ([Forms]![frmBilling]![txtjob]). The report functions
perfectly, except when there aren't any records in one of the sub reports.

The 8hourdays report is positioned above the 10hourdays report. If there
are not any record for the 8hourdays report, based on the job, there is a
blank spot in the report. The same goes for the 10hourdays report if there
aren't any records.

The reports are simple:

8HourDays
Label: Prisoner Wages [SumCountOfPrisoner] [8HourWages]
[SumCountOfPrisoner]*[8HourWages]
Label: Administrative Fee [SumCountOfPrisoner] [8HourAdmFee]
[SumCountOfPrisoner]*[8HourAdmFee]

10HourDays
Label: Prisoner Wages [SumCountOfPrisoner] [10HourWages]
[SumCountOfPrisoner]*[10HourWages]
Label: Administrative Fee [SumCountOfPrisoner] [10HourAdmFee]
[SumCountOfPrisoner]*[10HourAdmFee]

Is there a way to show the controls on these retorts even if there aren't
any records returned? I would like to show the labels and zeros in the
numeric fields.

Any ideas would be greatly appreciated. Thanks!

 

[Arvin Meyer [MVP]]

Yes. There are 2 ways that I know of. One that I wrote:

http://www.mvps.org/access/reports/rpt0007.htm

and one written by Keri Hardwick:

http://www.mvps.org/access/forms/frm0022.htm

Both work fine, but I prefer Keri's because it also checks for numeric
datatypes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access