J
jubu
I am using Access 2003 and have a query of daily entry information including
a Date field. I would like to be able to create another column that shows
the "Week Beginning..." for each of the dates. Example: 7/1/06 would show
the week beginning date as 6/25/06; 7/5/06 would show the week beginning date
as 7/2/06; etc.
I tried the DatePart function which converted the date to a serial number
representing the number of the week within the year, and thought of using a
table which correlates the number to a "week beginning date". However, that
doesn't work well if my query includes dates carried over to a different year.
Any suggestions would be MUCH appreciated!!!
a Date field. I would like to be able to create another column that shows
the "Week Beginning..." for each of the dates. Example: 7/1/06 would show
the week beginning date as 6/25/06; 7/5/06 would show the week beginning date
as 7/2/06; etc.
I tried the DatePart function which converted the date to a serial number
representing the number of the week within the year, and thought of using a
table which correlates the number to a "week beginning date". However, that
doesn't work well if my query includes dates carried over to a different year.
Any suggestions would be MUCH appreciated!!!