McSwifty,
After some sleep, it became clear that as beautiful as the db was designed, I would like to use rptyearview. So, qryYearView works fine as I do get appropriate results.
My issues are now:
1. a prompt for the parameter inputdate comes up and I can't see where it is coming from
2...