Z
Zippy the Pinhead
I have a database in which I keep track of cases. I have to run
queries that count for the occurrence of certain events and sum these
occurrences by quarter or by month depending on the prevalence.
I would like to query's output grid to show a zero (0) in the periods
during which there are no occurrences. Instead, the query's output
grid will contain no entry for which there are no occurrences. That's
inconvenient when, for example, I copy the contents of the query
output grid to Microsoft Excel or Minitab for graphing, control
charts, or analysis.
How can I make Access put a zero in the output query instead of
skipping the months or quarters during which the event in question
didn't happen?
Thanks.
queries that count for the occurrence of certain events and sum these
occurrences by quarter or by month depending on the prevalence.
I would like to query's output grid to show a zero (0) in the periods
during which there are no occurrences. Instead, the query's output
grid will contain no entry for which there are no occurrences. That's
inconvenient when, for example, I copy the contents of the query
output grid to Microsoft Excel or Minitab for graphing, control
charts, or analysis.
How can I make Access put a zero in the output query instead of
skipping the months or quarters during which the event in question
didn't happen?
Thanks.