Take the 2-minute tour ×  I'm trying to generate monthly records
in one table based on instructions in another table. Software -
MS Access 2007, though I'm looking for an SQL solution here. To
greatly simplify the matter, let's say the following describes
the tables:    - DayDue   - TaskName    - DateDue   - TaskName
So what happens is that there may be an entry in TaskManager
{15, "Accounts due"}, so this should lead to an "Account due"
record in the Task table with the due date being the 15th of
each month. I'd want it to create records for the last few
months and the next year.  What I'm thinking that I need to do
is first create a SELECT query that results in x records for
each record in the TaskManager table, with a date for each
month. After that, I do an INSERT query which inserts records
into the Task table if they do not EXIST in the aforementioned
SELECT query.  I think I can manage the INSERT query, though I'm
having trouble figuring out how to do the SELECT query. Could
someone give me a pointer?