Hi. For example, if the first datetime field is called time1, you can have a second column with the custom field type ‘formula’ and the formula as below. You might need to play around with the datetime formats using the “Formatting” tab for the formu...

Hi. You might need to provide some more information about the data you store - the names of relevant fields and data types. Are they dates, or just yes/no?

References seem to be the same other than versions. I don’t use the Dictionary class module at all. My table only import 60 or so rows, 15 columns. Can’t see how I can add the workbook here. Only allows pics. Is there another way?

Sorry - I see you already know where the error is. Not sure why there is a timeout. I’m using the latest excel but shouldn’t matter.

You could use F8, breakpoints and other debug tools to check where the error is. Also msgbox is a useful debug command. Seems that the table and view names need to be the ‘readable’ names, not the codes. For example my table is Centres and the view i...