Thank you - I think this forum is not going to be my saving grace when everyone is on leave!
Yes most recent - however some properties have been on the system prior to redevelopment and reimported so I need the most recent tenancy since import .... Eg. Tenancy Date must be > import date
😊 x
Bare with me everyone!
I am new to my job role and struggling with something to which no one is around to assist!
Basically in the query I need a Collumn to only output the greatest value that is given within the sub query. If that makes sense?
Eg. Tenancy start date must be the highest...
