Hmmnnn - not quite so simple, unfortunately (though that did work).
I've attached a screenshot showing what should happen- currently, there are 3 different recordsets, the third is meant to be a union of the first 2, but it isn't repeating.
The union recordset works when I try it in Navicat,
(BTW - if I was starting this from scratch, I wouldn't have 2 different methods of storing the birthday details - but I did this several years ago when I knew even less than I know now! 1 site type has the DOB, others don't need to record the year of birth)