I would like a function that can be used in my queries within Microsoft access.
The function would be named 'CurrentShift'
based on the current time now() I would like the function to display a different result based on the time.I would like a function created to store a shift time
Earlies - 07:00-15:00
Lates - 15:00 - 23:00
Based on the current system time i would like the function to give me the output of of e.g.
Times between 7:00-14:59 would give the function result of (Date()+#07:00:00#) And (Date()+#14:59:59#)
Times between 15:00-22:59 would give the function result of (Date()+#15:00:00#) And (Date()+#22:59:59#)
Times between 23:00-23:59 would give the function result of (Date()+#23:00:00#) And (Date()+1+#06:59:59#)
Times between 00:00-06:59 would give the function result of (Date()-1+#23:00:00#) And (Date()+#06:59:59#)
I would assume this would be a few if functions based on the current time.
Hello, so are you looking to type currentShift(now()) and then if is betwwen 07:00 - 15:00 then "Earlies" is returned? I'm sure I can do this in VBA for you, just want to make sure that I am understanding correct Daha Fazla
Bu iş için 3 freelancer ortalamada £18 teklif veriyor
Hi, I'd a professional VBA and Ms Access developer. I have read your project description and I'd like to design this function for you. However, I would like to take a look at the Ms Access file first. Looking forward Daha Fazla
Hello, I am very much interested on your project.I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Thanks