ouestque
asked on
AccessTable - Edit Dates
I have a table that lists dates. How would I query a second column that shows the Friday for the week each date falls in to?
Assume each week starts on Saturday and ends on Friday.
Assume Table Name: "tblListDates", FieldName: "DateList"
i.e. My table may have the following dates. (In reality there is 500K records spanning from 1998)
Date List New Column I would like (Shows Friday of every week date falls into.)
1/1/09 1/2/09
1/2/09 1/2/09
1/3/09 1/9/09
1/4/09 1/9/09
1/5/09 1/9/09
1/6/09 1/9/09
2/12/09 2/13/09
2/17/09 2/20/09
5/1/09 5/1/09
5/2/09 5/8/09
5/3/09 5/8/09
Notice how in the new column (Second Column) each date is a Friday. This represents the Friday of the week the date in the first column falls into (Assuming every week starts on Saturday and Ends on Friday.)
Assume each week starts on Saturday and ends on Friday.
Assume Table Name: "tblListDates", FieldName: "DateList"
i.e. My table may have the following dates. (In reality there is 500K records spanning from 1998)
Date List New Column I would like (Shows Friday of every week date falls into.)
1/1/09 1/2/09
1/2/09 1/2/09
1/3/09 1/9/09
1/4/09 1/9/09
1/5/09 1/9/09
1/6/09 1/9/09
2/12/09 2/13/09
2/17/09 2/20/09
5/1/09 5/1/09
5/2/09 5/8/09
5/3/09 5/8/09
Notice how in the new column (Second Column) each date is a Friday. This represents the Friday of the week the date in the first column falls into (Assuming every week starts on Saturday and Ends on Friday.)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.