Every Sunday of a month

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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))
Click to expand...

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

John W. Vinson [MVP]
 
John,

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

Thanks again,

DeWayne
 
Back
Top