How can you show on a report a count of "0" from a query that validly returns no records. This query appears as a subreport in my database and returns "counts" of events from a table and may return no records as the events have not occurred. In my report I want to show a count of "0" instead of a blank field. I've tried to accomplish this in my query with the Nz and IsNull functions and have had no luck. Thanks in advance!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
"Default" value on a report
- Thread starter medic133
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question