Every Sunday of a month

[Guest]

I have a database in which I need to assign tasks to people each Sunday. I
would like to have the user pick a month and year and have the form populate
4 or 5 fields with the Sundays in that month. So for August of 07 it would
populate 08/05/07, 08/12/07, 08/9/07 and 08/26/07. Then the date and people
will be saved in a table for that month. How can I accomplish this?

 

[John W. Vinson]

I have a database in which I need to assign tasks to people each Sunday. I
would like to have the user pick a month and year and have the form populate
4 or 5 fields with the Sundays in that month. So for August of 07 it would
populate 08/05/07, 08/12/07, 08/9/07 and 08/26/07. Then the date and people
will be saved in a table for that month. How can I accomplish this?

The simplest way would be to have a little auxiliary table with one date/time
field, filled with every Sunday from now through 2025 or so. You can fill this
easily by creating an Excel spreadsheet and using Fill... Series to generate
the dates; import or copy and paste the spreadsheet into a table.

YOu can then use an append Query based on this table using a criterion

= DateSerial(Year(Date()), Month(Date()) + 1, 1 AND < DateSerial(Year(Date()), Month(Date()) + 2, 1))

as a criterion on this table to select all the Sundays in the upcoming month.

John W. Vinson [MVP]

 

[Guest]

John,

Thanks, I like that idea about excel. I think I will try that.

Thanks again,

DeWayne