Can anyone help with the the problem statement I have shown on the attached excel spread sheet. I have tried (but failed) in trying to do this with a cross tab query. Is there any way I can achieve this natively inside of Access where the query shown in the attached Excel file as a table was created.
Thank you, and looking forward to some clues.