SubReports

[Guest]

I have a report with 2 subrpt this is my formula on my 2ndsubrpt
=Reports!rptLotterysalesByStore!Text51-Reports!rptLotterysalesByStore![LotteryInventoryPaid
Grand Total Sum]+Reports!rptLotterysalesByStore![TerminalFee Grand Total
Sum]+Reports!rptLotterysalesByStore!qryScratchOffTicketsActivatedByStore.Report![Grand Sum Of Cost]

My problem is if the [Grand Sum Of Cost] is null my 2 subrpt = name
I trying to use a NZ but not getting no where

Any help Thanks Mike

 

[Arvin Meyer [MVP]]

I have a report with 2 subrpt this is my formula on my 2ndsubrpt
=Reports!rptLotterysalesByStore!Text51-Reports!rptLotterysalesByStore![LotteryInventoryPaid
Grand Total Sum]+Reports!rptLotterysalesByStore![TerminalFee Grand Total
Sum]+Reports!rptLotterysalesByStore!qryScratchOffTicketsActivatedByStore.Report![Grand
Sum Of Cost]

My problem is if the [Grand Sum Of Cost] is null my 2 subrpt = name
I trying to use a NZ but not getting no where

Any help Thanks Mike

Have a look at:

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

or:

http://www.mvps.org/access/forms/frm0022.htm
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com