Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreports in a report?

Status
Not open for further replies.
Atomsk

Atomsk

MIS
Jun 3, 2003
60
US
In a report, I have a field [SeqNumber]. I also have a text box that counts the number of records returned by the query that the report is based on:

=Nz(IIf(IsNull([SeqNumber]),"0",Count([SeqNumber])))

The above works just fine in this one report, but if I add it to another report as a subreport, the string "0" will not appear if [SeqNumber] is null. Nonzero values show up just fine, though. Help anyone? Thanks.
 
Sort by date Sort by votes
Ah, guess I should have read the first page before posting. Disregard.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
706
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
572
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
556
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
533
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
3K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top