Formatting Dates

[Marcus]

I know how to fromat dates by weeks, as in Format([Date],"ww").
However, this displays the week as a number, such as 1, 2, 3, 4, to
represent 1st week, 2nd week etc of the year.
I am wondering if there is a function in Access that will display the
actual dates of each week in the year. For instance, I want to display
Jan 1-7 (as week 1), Jan 8-15 (as week 2) etc. Is this possible in
Access?
Marcus
******

[pietlinden]

Possible, sure. As easy as a straight format, no way. You can do it
with date manipulation functions pretty easily. So what's your end
goal? Just a list of weeks?
1. Get the first day of the year
2. Add six days to that to get the last day of that first week (use
DateAdd).
3. Write those somewhere (a table sounds like a fun place).

4. Add a week to the result in 1.
5. Repeat steps 2 and 3 until you've done all the dates you want. (I
sense a do loop in there...)
Why exactly did you need this? There may well be an easier answer to
your question. But I can't tell from the information provided.

[Marcus]

I'm looking to do something like this in my query:

Start Week---Total Courses Starting---Courses Starting by Subjects

Aug 16-31---2-----ESL-----------------------------1
-------------------------Professional Studies-----1
Sept 1-2------51---ESL-----------------------------5
-------------------------Professional Studies-----9
-------------------------Languages-------------------37
Sept 2-11----18---ESL-----------------------------1
-------------------------Professional Studies-----10
-------------------------Languages-------------------7

Marcus
********