Search results

That's perfect. Can't believe I was so close - had tried changing type to Variant after discovering that this was the only variable type that you could assign a null value to, but didn't quite have the IsNull() function right (I was using dteEndDate is Null!!) Thanks for the help Regards...

I've recently found this thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51941&highlight=dates with some really useful code added by Mile-O. I've amended the GetBankHoliday function slightly to take care of Xmas / New Year dates that land at weekends and this is...