K
karen
I have generated a report that runs off of a query. In the underlying table of the query, there is no data for the criteria set, which is okay. There are calculations in the report to give a sum and a total count. But since there is no data to get, the report returns "error" in the field on the report. Instead of displaying "error", how can I have something displayed on the report that says something like "there is no data available for this report"? I thought about an event procedure on error, but it is not working. This is one of several reports of the same, but there is data available. Can anyone help me? Thanks.