#Error in group footer

D

Duane

I have a text box in the group footer that does a count.

=(Count([KeyName]) & " " & "Total key(s) added for" & " " & [DateAdded])

The problem I am having is that I get an #error message if there are no
records to display.

Is there a way to hide that error message when there aren't any records, and
display a label that says "There were no keys added during this time
period!"? The report is in memo form and I need to submit the memo even if
there weren't any keys added for the month, but I don't want the error
message.

Thanks in advance.
 
D

Duane

Thanks for your help.


Larry Daugherty said:
Look for an event on no data.

HTH
--
-Larry-
--

Duane said:
I have a text box in the group footer that does a count.

=(Count([KeyName]) & " " & "Total key(s) added for" & " " & [DateAdded])

The problem I am having is that I get an #error message if there are no
records to display.

Is there a way to hide that error message when there aren't any records, and
display a label that says "There were no keys added during this time
period!"? The report is in memo form and I need to submit the memo even if
there weren't any keys added for the month, but I don't want the error
message.

Thanks in advance.
Click to expand...
Click to expand...
 
Top