Recent content by TH1

All, Thanks for your thoughts The data is like this because, it's a view over an existing SharePoint list that has a lot of live data in and isn't going to be changed to optimise a data model in a reporting solution. I'm aware there are ways around this but happy with my fast and dirty...

Thanks for the swift response. That has sorted it for records where there are dates in both fields. SO it implies that it is type related. Unfortunately it is possible that EV2 Date will be blank... I've changed the code in the function to populate values where it is null. Function...

Dear All, I am trying to find the latest date in a table where the dates are in 2 separate columns and multiple rows. (there are business reasons why there are 2 dates per row they represent different but comparable activities) I have a table "Assessment tracker" with the following structure...

Hello All, New to Access so expect the worst...