=DSum("[total affected]","all outages board summary","[event]='bad underground' And [Outage Type]='L'"
.
I'm using the above expression in a report to look at a query to find the total number of customers affected by this particular type of event. There are about a dozen different type of events, this is just one. I'm giving Access a date range from a form, But if it does not find that event in the time period it leaves a blank on the report. What do I need to add to this so that if Access does not find the event in the expression it will show a Zero "0" on the report and not a blank.
.I'm using the above expression in a report to look at a query to find the total number of customers affected by this particular type of event. There are about a dozen different type of events, this is just one. I'm giving Access a date range from a form, But if it does not find that event in the time period it leaves a blank on the report. What do I need to add to this so that if Access does not find the event in the expression it will show a Zero "0" on the report and not a blank.