Devam Ediyor

Microsoft Access Function based on time

hello all.

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

Shifts are

Earlies - 07:00-15:00

Lates - 15:00 - 23:00

Nights 23:00-07: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.

Beceriler: Veritabanı Programlama, Excel, Microsoft Access, SQL, Visual Basic

Daha fazlasını gör: ms access time functions, ms access time(), ms access vba now(), ms access get time from datetime, ms access convert text to time, ms access timevalue, ms access time format, ms access current date and time, microsoft excel function formula, access function mailto, access function search, access function sendemail, access function quick search, access function accounting examples 2007, access form output based user input, microsoft project function formula, creare pdf access function, access function pdfcreator, access function pdf, microsoft access function

İşveren Hakkında:
( 7 değerlendirme ) Le193ej, United Kingdom

Proje NO: #16241445



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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(12 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(68 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(1 Yorum)