Thread: Error message appears when multiple people Access Database
View Single Post
  #31 (permalink)  
Old 01-12-2008, 04:22 AM
Juggler Juggler is offline
Junior Member
  
Join Date: Oct 2007
Posts: 6
iTrader: (0)
Juggler is on a distinguished road
Default Display a count of "0" in report
I have a report that through query counts the number of records in a table for display. My problem is that if there are no records I am getting "#error". How can I display a "0", if there are no records?
In the text box this what I have, =[table].[count]
Any suggestions
Reply With Quote