I'm looking for a query to return the latest date in column ("Last Inspection") from tbldata for every equipments in tblEquipment found in the column ("PairEquipemnt").
Is there an easy way to split the pair of equipment column as in your picture to make the table1?
Michael Noze
ASKER
A little update..I made a query to separate the two numbers and another query to put everything in a single column.
I also tried to write a function to have the desired output, but it seems to always be blank.
Is there a solution to this? Database8.accdb
Is there an easy way to split the pair of equipment column as in your picture to make the table1?