G Guest Mar 28, 2004 #1 I want to be able to enter a day an employee works and have access automatically enter the date of the beginning of the work week that that date falls into.
I want to be able to enter a day an employee works and have access automatically enter the date of the beginning of the work week that that date falls into.
T TIm Brown Mar 29, 2004 #2 The following code might help: =Date()-(Weekday(Date())-2) Entering that into the default value for a control will cause the control to show the beginning of the current week. If you change the Date() part to any date, it will show the Monday for the week into which that date falls. -----Original Message----- I want to be able to enter a day an employee works and Click to expand... have access automatically enter the date of the beginning of the work week that that date falls into.
The following code might help: =Date()-(Weekday(Date())-2) Entering that into the default value for a control will cause the control to show the beginning of the current week. If you change the Date() part to any date, it will show the Monday for the week into which that date falls. -----Original Message----- I want to be able to enter a day an employee works and Click to expand... have access automatically enter the date of the beginning of the work week that that date falls into.
