Recent content by cardiffpete

Hi Guys Thanks for the suggestions, I can only work on this when the prerssure on other work areas is less!! I had tried a range of options, having worked out that by returning a number for the seconds, any leading zeros vanish (ie, 08 becomes 8, and 00 seems to vanish altogether). A series of...

Hi Thanks for the info, sorry it has taken a bit of time to reply but I have had other things to occupy me at work! I have tried your suggestion, and it produces a result, but this is lower than the method originally tried (full hour range OR specific hour and < 30 mins). At present I cannot...

Hi Can anyone advise on the following query problem: I have been using the function DatePart to select records from a field of a datetime type, and had seen somewhere (an old Access refrence book?) that it is possible to use DatePart to select more than one time setting, but I have not found...