MS Access-How to query records based on the most recent date in a field that includes the quarter?

I have 2 tables the share the same serial number.  One of the tables has a field with a report date.  There are multiple records for the same serial number with different report dates.  I need to run a query that will show the most recent report date for that serial number.  

Example: 

Serial number      Report Date

M123456             2017 Q1

M123456             2018 Q4

M123456             2019 Q1

M123456             2019 Q2

Desired output for this record
Serial number      Report Date
M123456             2019 Q2