Half-day leave computation

[bsvubana]

if half-day leave is checked in my sub-form deduction should be .5 days. How can I total all "Days applied" in my subform and show the result computation in my "Available Leaves" in my mainform

Available Leaves = Leave Allocation - Days applied

Note: If half-day leave is checked deduction is .5 days applied.

I Attached my working database. Thanks

[June7]

You show leave range of 9/10/2012 to 9/15/2012. The 10th through 15th is a 6-day period inclusive of the begin/end dates. DateDiff calculates this range as 5 days but if the leave range should be inclusive of the begin and end dates (and in my experience with payroll, that is customary) then the number of days is 6.

Can the 'halfday' option apply to more than one day? I ask because you show some records like that in the Transaction table.

Enter the date range as inclusive, such as 9/10/2012 to 9/14/2012 and consider:

Days applied: (DateDiff("d",[datefrom],[dateto])+1)*IIf([halfday]=True,0.5,1)

How do you want to handle if date range crosses weekends and holidays?

[recyan]

Try using

Days applied: IIf([halfday]=0,DateDiff("d",[datefrom],[dateto]),0.5)

in your query.

Thanks

Edit : Sorry June, missed your post.

[bsvubana]

Guys, Thanks so much for this it solved my query problem! How could I bypass weekends and holidays on the specified date range to be counted?

[June7]

That gets complicated.

Google: calculate date difference excluding weekends holidays

Review http://bytes.com/topic/access/answer...idays-weekends

[bsvubana]

thanks much!