Search results

Can you post a copy of the db

I don't think my original suggestion gave the desired results when the time was 03:00 am Don't understand why you are making comments on the use of Now() function. I haven't used it:unsure:

I've looked at this again. The following works for me: =IIf(Hour([BusinessDatetime])*60+Minute([BusinessDatetime])<=180,[BusinessDatetime],[BusinessDatetime]+1)

Try: =IIf(Hour([BusinessDatetime])<=3,DateValue([BusinessDatetime])+1,DateValue([BusinessDatetime])) as the Control Source of [businessday]

Can you post a copy of your db

Welcome to the forum :)

Welcome to the forum :)

Perhaps you need to change from Tabbed Documents to Overlapping Windows. See this short video...

Well quite!! but if you simply count the number of days in the period of leave, that's what happens;)

Also, keep in mind that you would need something other than Access for the backend if the network is not a wired network.

<Phuduhutswana> When entering and calculating leave taken, will your app need to differentiate between the employee's usual working days and those that are not usual working days? i.e. if an employee usually works Mon - Fri (5 days) and goes on leave for one week, will you calculate that as 5...

Oh, George. I admire your eloquence.

Yes, you can also walk off a kerb at the side of the road and cross it with your eyes closed and your hands over your ears. Just because you can doesn't mean that you should. Read the following link for an explanation of why you shouldn't ;) Evils of Lookups in tables

"Store accrued leave days" the number of "Leave Days" taken should not be stored in a table. Calculations should be done as and when needed. I hope these "Lookup" are being used on a form to store the PK and NOT as lookups at the table level. BTW Welcome to the forum :):)

Your welcome. I suspect that it's all about understanding the maths ;)

Perhaps: =([Current_Price]-[Stop_Current])/[stop_current]

Might be better to use a subform or a listbox.

Indeed. Thank you for the correction.

Perhaps something like: =([Current_Price]-[Net_Share_Cost])/[Net_Share_Cost] as the Record Source of the textbox called Percentage_PC If you are intending to do anything else with this db I would suggest that you Normalize it and get rid of the many "Lookup" fields that you have. Lookups...

Welcome to the forum :) It is probably best to start a new thread with whatever is troubling you if you can't find the answer in an earlier thread.