#Error from Count

[Leif]

I'm trying to show a total count of the records in a report. In the report
footer I have the function "=Count([pmocid])" where pmocid is a field in the
report detail. Works fine until there are no records in the report. Then I
get a "#Error". I tried =Count("*") instead, but I got the same error.
Anyway to trap this problem and drop in a zero, or another way around the
problem?

Thanks,
Leif

 

[Duane Hookom]

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

 

[Leif]

Thanks, that's a new one for me. So the HasData is like a pseudo column?

Check for HasData
=IIf([HasData],Count(*),0)
--
Duane Hookom
Microsoft Access MVP

I'm trying to show a total count of the records in a report. In the report
footer I have the function "=Count([pmocid])" where pmocid is a field in the
report detail. Works fine until there are no records in the report. Then I
get a "#Error". I tried =Count("*") instead, but I got the same error.
Anyway to trap this problem and drop in a zero, or another way around the
problem?

Thanks,
Leif

 

[Duane Hookom]

HasData is a property of the report. This property will return true or false
depending on if the report's recordsource has any records.
--
Duane Hookom
Microsoft Access MVP

Thanks, that's a new one for me. So the HasData is like a pseudo column?

Check for HasData
=IIf([HasData],Count(*),0)
--
Duane Hookom
Microsoft Access MVP

I'm trying to show a total count of the records in a report. In the report
footer I have the function "=Count([pmocid])" where pmocid is a field in the
report detail. Works fine until there are no records in the report. Then I
get a "#Error". I tried =Count("*") instead, but I got the same error.
Anyway to trap this problem and drop in a zero, or another way around the
problem?

Thanks,
Leif