Rick,
I'm not sure I understand what you are trying to do. Do you want to run a
query and have it return the starting day of the week, or just the
weeknumbers that fall in a particular quarter?
If you had a table (tbl_Numbers) with the numbers 0 through 365 in a
field
called Number you could write a query that looks something like:
SELECT DateAdd("d",[Number],#1/1/2007#) AS SomeDate,
DatePart("q",DateAdd("d",[Number],#1/1/2007#)) AS [Quarter#],
DatePart("m",DateAdd("d",[Number],#1/1/2007#)) AS [Month#],
DatePart("ww",DateAdd("d",[Number],#1/1/2007#)) AS [Week#],
Weekday(DateAdd("d",[Number],#1/1/2007#)) AS WeekDay
FROM tbl_Numbers
WHERE DatePart("q",DateAdd("d",[Number],#1/1/2007#))=[Enter quarter]
AND Weekday(DateAdd("d",[Number],#1/1/2007#))=1
ORDER BY DateAdd("d",[Number],#1/1/2007#);
HTH
Dale
------------------------------
Don''t forget to rate the post if it was helpful!
Email address is not valid.
Please reply to newsgroup only.
Rick Stahl said:
DatePart("q",[name]) works for quarters for the year (total is 4)
DatePart("ww",[name]) works for weeks of the year (total is 52)
How can I determine weeks within the quarter (should be total of 13) ?
Thanks.