Write a SQL statement to insert dummy records into an access 2010 database table with set values for each day of a particular month.
Let's say the month is June it will create records for every day in June from the 1st to the 30th so that my union queries display correctly since access doesn't have the ability for outer joins (I think) hence the need for dummy records.
The statement will also include a max lookup for one table which will then insert related records into a related table for the count of records in that table. So say June, 30 days, 30 records into both tables with set values.
Easy enough, I am stuck with the routine to tell it how many records to create and to change the date in one field. This is beyond my current abilities.
Thanks in Advance