Okay, as always someone's suggestion nudged me in the right direction.
For the benefit of anyone who may have the same problem, what I ended up doing was as follows.
I used the same query twice, thereby removing the need for the YTD query.
SELECT
Format(qry_Month_Totals.Date,"mmmm...