B BB Registered User. Local time Today, 21:59 Joined Aug 31, 2001 Messages 30 Nov 6, 2001 #1 I have a report with several subreports. In the footer I total the subreports. Is there some way I can just print those totals that are positive (or negative)? Thanks, NewToAccess
I have a report with several subreports. In the footer I total the subreports. Is there some way I can just print those totals that are positive (or negative)? Thanks, NewToAccess
M MrTibbs Registered User. Local time Today, 21:59 Joined Oct 10, 2001 Messages 101 Nov 6, 2001 #2 Here's what i'd try: =iif(yoursum <> 0, yoursum, "") basically saying print yoursum or a blank.