Query totals displayed in a report is it possible

[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.

 

[Rick Brandt]

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.

Can be difficult. You would need a table poulated with all possible months and
outer join to that in your query so that all months are displayed by pulling
them from the table of months instead fo from your data table.

Exception is if your query is a crosstab query with months being the columns
produced byt the crosstab. Then you can use the ColumnHeadings property to
force the display of all desired columns even if the data does not include
records for every column being produced.