Ok dudes heres the thing.
Thanks to the smiley one i have a code that sorts out a 5 day week but the problemo is i dont know how to use it with the form. i created a module with the code in but when i go onto my form the formula i have for dates doesnt reflect a 5 day week.
=DateAdd("d",5,[DateCourseworkG iven])
if i use that with todays date it gives an answer of the 22nd September instead of...
3 results in 0.0037 seconds.
-
USe a module on a form
-
John Crozier started a topic SQL Statement - Selecting between dates using dateadd() and dateserial()in AccessSQL Statement - Selecting between dates using dateadd() and dateserial()
Hello everyone,
I was recently tasked to convert some of the functions employees use Excel for into Access. One of these functions is seeing which invoices are due to be paid this month. Surely this is simple I thought, and so it would be - if I had a field with a duedate in it. However I am using the sum of two fields as my date and thus, I feel, I have a problem. It's the end of the day and I'm knackered, can anyone spot my Query... -
Calculate Date Differences Excluding Holidays/Weekends
I know this topic is a veritable dead horse, but I have to ask, because I am unable to find something that is close to my scenario that I can completely understand.
I have a start date field and complete date field.
I need to know how many days, minus holidays and weekends are between the two dates. i already have the table of holidays named "holiday table" with the field being named "Holidaydat e"....
