Search results

Hi Bob Thanks for replying. I’m sorry that I can't post the database as I will not be back in work for a while and don’t have MS Access at home. I think it would be too large a file anyway as the training section is only one small part of a huge database. I’ll attempt to explain what I am...

Hi Bob I'm glad to say that the query is now functioning so thanks for your help there! Where should I go from here? I've attempted to split up the training details from the training dates and create a relationship but am not sure if this is the correct way to go about it? Thanks again for all...

Hi Bob Thanks for your reply - it is much appreciated! If you could please provide the example you mentioned that would be great. Please forgive my ignorance - I'm a definite novice when it comes to VBA! I had originally attached the datediff function to a "no. of training days" field in a...

I am still struggling to find the solution to this - does anyone know how I can calculate the work days/half days and hours? This is all I need to find out before I am completely finished my database so I'm really keen to find the answer! Thanks for your help.

Thank you for replying - its much appreciated. I will have to calculate in work days and half work days, I'm afraid (full day 9am to 5pm, half day 9am to 12 noon). Do you know how I would go about doing this?

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...