am working on an Access 2010 database.
Each record has a date stamp. I would like the query to output the date with a corresponding week number.
I would like this information to link to a table with the date at the start of the week, the date at the end of the week.
for example, the table would look like this:
ID: 1
wkBegin: 12/29/14
wkEnd: 1/4/15
ID: 2
wkBegin: 1/5/15
wkEnd: 1/11/15
When linking to the table with my dates, I have two examples of dates: 12/30/14 and 1/10/15
I would like the output to look like this
Wk: 1 Date: 12/30/14
Wk: 2 Date: 1/10/15
I know I would need to have the two tables linked in a query.
My query will pull down the fields for weeknumber, date
How would I go about doing this?