#Error in group footer

  • Thread starter Thread starter Duane
  • Start date Start date
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LIne # on continuous subform 0
Report Footer 2
Group Footer and Page Footer 6
A03 - count in report footer gives me #Error? 0
Need Help to Count in Footer, then Sum in 2nd Footer then Sum agai 1
Orphan Footers 2
Count Value in a report footer 1
DCount in group footer 4

Back
Top