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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Reports Count(*) Error

Status
Not open for further replies.
gwoman

gwoman

Programmer
Nov 16, 2004
199
US
Hi All ...

I know I am probably over thinking this and there is a simple answer ...
I have an Access Reprot that displays all incidents within a container ... for containers witin a region ... that fall under a user specified permit number ... I am using the Count(*) on the report to capture the # of Incidents per Region ... and then again to Capture the total # of Incidents per Permit Number ...
It all works fine unless there are no incidents and then it displays ( #Error ) on the report.
I would like it to display a 0 (zero)if there are no incidents.
I tried to put an IIf statement in the control source for the report control but that did not work ...
Any ideas would be greatly appreciated ...
Thanks!
G
 
Sort by date Sort by votes
Nevermind ... Figured it out ...

=IIf([HasData], Count(*), 0)

Thanks!
g
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
403
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
2K
renigar
renigar
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
3K
EwaFAMA
EwaFAMA
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
213
GPnew
GPnew
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
362
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top