Query

J

Jerri

I have created a query and a report for the query. The query calculates the
number of devices produced each month and then the total for the year. When
the report displays the totals, it displays nothing if one of the months has
no devices produced. Is it possible to set the query or the report so that
when no devices are produced in a given month, that a zero is displayed so
that the total will be displayed even though some months are zero.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top