Search results

I used the datediff function to calculate the number of days a training event has taken: Datediff("d",[Training Date From],[Training Date To]+1 This works for calculating training in whole days but what I really need to do is calculate when a training event only lasts for half a day (from 9am...

I have an access database used for recording training events. I was able to calculate the number of days each training event took by using Datediff("d",[Training Date From],[Training Date To]+1) I was really chuffed with this until my boss asked what happens when the training only lasts half...