This has probably been asked a million times before but i can`t find a reply that suits my problem!!
I need to add a text box to my form with a formula that calculates the days between 2 separate date fields within my form (excluding weekends). I know Access doesn`t recognise NetWorkDays as it does in Excel.
I have created a table with a list of weekend dates and bank holiday dates that i want to minus from my formula but have no idea how to do this!
Any ideas gratefully received. I am not advanced enough to use 'code' so an idiot guide also gratefully recieved if this is the suggested route
thanks
I need to add a text box to my form with a formula that calculates the days between 2 separate date fields within my form (excluding weekends). I know Access doesn`t recognise NetWorkDays as it does in Excel.
I have created a table with a list of weekend dates and bank holiday dates that i want to minus from my formula but have no idea how to do this!
Any ideas gratefully received. I am not advanced enough to use 'code' so an idiot guide also gratefully recieved if this is the suggested route
thanks
