Access SQL Update with Max not working

Hi

In Access I am getting the error "Your query does not include the specified expression ‘LastRenewalDate’ as part of an aggregate function" for the following

UPDATE t_Licence INNER JOIN t_Renewals ON t_Licence.LicenceNumberPK = t_Renewals.LicenceNumberFK SET t_Licence.LastRenewalDate = Max(t_Renewals.RenewalDate)
WHERE (((t_Renewals.LicenceNumberFK)=[t_Licence].[LicenceNumberPK]));

I previously ran the query without the Max in it and it worked fine

UPDATE t_Licence INNER JOIN t_Renewals ON t_Licence.LicenceNumberPK = t_Renewals.LicenceNumberFK SET t_Licence.LastRenewalDate = t_Renewals.RenewalDate
WHERE (((t_Renewals.LicenceNumberFK)=[t_Licence].[LicenceNumberPK]));