Access - Get Latest Date If Column Contains Value From Another One

I'm having an issue with a VBA function for my query in Access. I have a table 'tbldata' Equipment Last Inspection 420-413 2019-06-15 440-433 2019-06-15 402-483 2019-

Solution 1:

If you want a query that returns your expected results, you can join the table and the query with the use of the operator LIKE:

SELECT q.UnpairEquipment AS Equipment, MAX([Last Inspection]) AS [Latest Date]
FROM qryunpair AS q INNERJOIN tbldata AS t
ON'-'+ t.Equipment +'-'LIKE'*-'+  q.UnpairEquipment +'-*'GROUPBY q.UnpairEquipment

Results:

EquipmentLatestDate4022019-06-294132019-12-124202019-12-124332019-06-154402019-06-154832019-06-29