Computing using Query

[spideynok]

Hi! I had this formula on my Excel project.

=IF(ISBLANK(I4),"",(NETWORKDAYS(F4,I4,HolidayList)-1)*(DayEnd-DayStart)+IF(NETWORKDAYS(I4,I4,HolidayList),MEDIAN(MOD(I4,1),DayEnd,DayStart),DayEnd)-MEDIAN(NETWORKDAYS(F4,F4,HolidayList)*MOD(F4,1),DayEnd,DayStart))

then I want to use it on MS Access, on my last code I change all the I4,F4 etc in my query and I put the column that it will compute, but there's an error appearing and Highlighting the word MOD.

What can I do to make it correct? Thanks in Advanced

[June7]

Show the Access version of the expression you attempted so we can analyse. Syntax for MOD function in Access/VBA would be: 8 Mod 3

Also, there is no intrinsic Median or NetworkDays functions in Access/VBA. ISBLANK would probably become IsNull.