VBA - 13 month rolling data with missing months

[tbelly82@gmail.com]

I am using an access database to populate a Word template with chart data. I am using 13 month rolling data, however some months have no value, but i still want this to be displayed in the chart and it is not, it just skips the month any ideas how i would do this? Very new to VBA

[ranman256]

I have a report table to dump my data in.
Qry1: add all months to it NO data.
Qry2 add my data I'm reporting on.
Qry3 is the report qry to sum all values per month.

[ItsMe]

Handle Nulls by replacing them with a value such as Zero for number types and Literal text for Text types, e.g. "No Activity"