Not sure. never done that before.my guess is it will need to write ad-hoc query.
so need to be fast and accurate.
if it is a formal report need to be gernated daily/monthly, the role shd be under a formal IT project.You can focus more on Access queries.
good luck!
Thank you so much!