#Error for CountOf

  • Thread starter Thread starter dave.degroot
  • Start date Start date
D

dave.degroot

My function in my report : "=Sum([CountOfEmployee_id]", which works
whenever a query contains records, returns the following when a query
contains no records: "#Error"

When I try:
IIf(Sum([CountOfEmployee_id])>0),Sum([CountOfEmployee_id]),"")

It still returns "#Error" I've tried several other combinations for
the function as well...

Thanks!
 
This would be more appropriate in the reports news group however,
=IIf([HasData]=True,Sum([CountOfEmployee_id]),0)
 
This would be more appropriate in the reports news group however,
=IIf([HasData]=True,Sum([CountOfEmployee_id]),0)

--
Duane Hookom
Microsoft Access MVP



[email protected] said:
My function in my report : "=Sum([CountOfEmployee_id]", which works
whenever a query contains records, returns the following when a query
contains no records: "#Error"
Click to expand...
When I try:
IIf(Sum([CountOfEmployee_id])>0),Sum([CountOfEmployee_id]),"")
Click to expand...
It still returns "#Error" I've tried several other combinations for
the function as well...
Click to expand...
Thanks!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Oh, yes, you're right! thanks anyway!
 
Back
Top