Access 2007 list all the Sunday and Saturday in a year?
Is there any way to list all the Sunday and Saturday for a given year (2013 for example) in Access ? I tried to search and see that VBA might do the trick. What I want is that I have a Form that ask for user to input [Start Date] and [End Date]. I want to calculate the [Working days] = [End Date] - [Start Date] - (any Sunday and Saturday in between if available). So I am thinking of listing all the Sunday and Saturday in that year first then somehow trying to calculate the [Working days]. Any ideas would be appreciate . Thank you. >.<
Is there any way to list all the Sunday and Saturday for a given year (2013 for example) in Access ? I tried to search and see that VBA might do the trick. What I want is that I have a Form that ask for user to input [Start Date] and [End Date]. I want to calculate the [Working days] = [End Date] - [Start Date] - (any Sunday and Saturday in between if available). So I am thinking of listing all the Sunday and Saturday in that year first then somehow trying to calculate the [Working days]. Any ideas would be appreciate . Thank you. >.<
No comments:
Post a Comment