Hello All! First just let me say what a great forum this is. I'm not that new to Access, but haven't used it in donkey's years. I have created a new Access database for our department, and while it is simple, I am pretty proud of it. I even got a couple of answers off this forum.
My problem is twofold, one, I am using the DATEDIFF function to calculate the difference between dates for several fields, and I want it to consider the normal holidays throughout the year not not calculate those days, like the NETWORKDAYS function in Excel:
=IF($O14="","",IF($P14="",NETWORKDAYS($O14,$A$5,Lists!$G$2:$G$12),NETWORKDAYS($O14,$P14,Lists!$G$2:$G$12)))
I have created the Holiday Schedule Table but do not know where to insert that parameter.
The second problem is that the days calculated do not display until well after the dates are entered. I would like them to display instantly. I have tried the OnDirty, OnUpdate, OnChange, etc, but no luck.
Thank you in advance for any information that might help!!!
My problem is twofold, one, I am using the DATEDIFF function to calculate the difference between dates for several fields, and I want it to consider the normal holidays throughout the year not not calculate those days, like the NETWORKDAYS function in Excel:
=IF($O14="","",IF($P14="",NETWORKDAYS($O14,$A$5,Lists!$G$2:$G$12),NETWORKDAYS($O14,$P14,Lists!$G$2:$G$12)))
I have created the Holiday Schedule Table but do not know where to insert that parameter.
The second problem is that the days calculated do not display until well after the dates are entered. I would like them to display instantly. I have tried the OnDirty, OnUpdate, OnChange, etc, but no luck.
Thank you in advance for any information that might help!!!
