#Error for CountOf

[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!

 

[Duane Hookom]

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

 

[dave.degroot]

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

--
Duane Hookom
Microsoft Access MVP

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!- Hide quoted text -

- Show quoted text -

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